metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax_kingdom = "Thermotogati"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6319462	6319462	PRJNA792582_P_NODE_39145_length_280_cov_1.338164_g38331_i0	PRJNA792582	39145	280	1.338164	3.7468592	Deinococcus	1298	Bacteria	Bacteria	479	9.99e-131	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g38331	i0	97.509	108.367857142857	281	5	100	2	1	280	1015	1294	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	30343	479	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
7155501	7155501	PRJNA792582_P_NODE_49546_length_251_cov_1.522472_g48732_i0	PRJNA792582	49546	251	1.522472	3.82140472	Deinococcus ficus	317577	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g48732	i0	98.805	1	251	3	100	0	1	251	768043	767793	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	251	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
7155516	7155516	PRJNA792582_P_NODE_50466_length_250_cov_1.711864_g49652_i0	PRJNA792582	50466	250	1.711864	4.27966	Deinococcus aetherius	200252	Bacteria	Bacteria	324	4.35e-84	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g49652	i0	90.119	165.148	253	20	100	5	1	250	83131	82881	Deinococcus aetherius ST0316 DNA, complete genome	blastn	41287	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
8430233	8430233	PRJNA792582_P_NODE_49407_length_251_cov_2.089888_g48593_i0	PRJNA792582	49407	251	2.089888	5.24561888	Deinococcus aquaticus	328692	Bacteria	Bacteria	191	4.62e-44	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g48593	i0	80.632	15.4183266932271	253	43	99	6	2	251	601490	601241	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	3870	191	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
8430327	8430327	PRJNA792582_P_NODE_56147_length_244_cov_1.801170_g55333_i0	PRJNA792582	56147	244	1.80117	4.3948548	Deinococcus aetherius	200252	Bacteria	Bacteria	357	4.16e-94	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g55333	i0	93.033	2.0327868852459	244	17	100	0	1	244	2373925	2374168	Deinococcus aetherius ST0316 DNA, complete genome	blastn	496	357	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
10980905	10980905	PRJNA792582_P_NODE_35669_length_289_cov_1.425926_g34855_i0	PRJNA792582	35669	289	1.425926	4.12092614	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	494	3.7e-135	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g34855	i0	98.913	1.91003460207612	276	3	96	0	1	276	2174449	2174724	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	552	494	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
11419268	11419268	PRJNA792582_P_NODE_29629_length_317_cov_1.262295_g28815_i0	PRJNA792582	29629	317	1.262295	4.00147515	Deinococcus	1298	Bacteria	Bacteria	392	1.54e-104	NTclustered	gi\|485099143\|ref\|NR_102538.1\|	432329	g28815	i0	88.994	192.757097791798	318	33	100	2	1	317	1512	1828	Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence	blastn	61104	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
11419479	11419479	PRJNA792582_P_NODE_52169_length_249_cov_0.875000_g51355_i0	PRJNA792582	52169	249	0.875	2.17875	Deinococcus	1298	Bacteria	Bacteria	344	3.32e-90	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g51355	i0	91.566	51.6706827309237	249	21	100	0	1	249	2927124	2927372	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	12866	344	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
11419546	11419546	PRJNA792582_P_NODE_58549_length_242_cov_0.911243_g57735_i0	PRJNA792582	58549	242	0.911243	2.20520806	Truepera	332248	Bacteria	Bacteria	259	1.2e-64	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g57735	i0	85.95	34.1115702479339	242	34	100	0	1	242	778532	778291	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	8255	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
14805766	14805766	PRJNA792582_P_NODE_56772_length_244_cov_0.900585_g55958_i0	PRJNA792582	56772	244	0.900585	2.1974274	Deinococcus ficus	317577	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g55958	i0	99.18	20.8483606557377	244	2	100	0	1	244	838240	837997	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	5087	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
14805782	14805782	PRJNA792582_P_NODE_58892_length_241_cov_1.833333_g58078_i0	PRJNA792582	58892	241	1.833333	4.41833253	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g58078	i0	100	1	241	0	100	0	1	241	120426	120186	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	241	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
16079546	16079546	PRJNA792582_P_NODE_44993_length_264_cov_1.612565_g44179_i0	PRJNA792582	44993	264	1.612565	4.2571716	Deinococcus aquaticus	328692	Bacteria	Bacteria	152	2.31e-32	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g44179	i0	90.435	1.33333333333333	115	11	44	0	1	115	1358087	1358201	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	352	152	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
17355223	17355223	PRJNA792582_P_NODE_35514_length_289_cov_2.578704_g34700_i0	PRJNA792582	35514	289	2.578704	7.45245456	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	534	2.18e-147	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g34700	i0	100	204.356401384083	289	0	100	0	1	289	1638990	1638702	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	59059	534	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
17355397	17355397	PRJNA792582_P_NODE_49154_length_252_cov_1.675978_g48340_i0	PRJNA792582	49154	252	1.675978	4.22346456	Deinococcus aetherius	200252	Bacteria	Bacteria	267	7.499999999999999e-67	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g48340	i0	92.473	0.865079365079365	186	14	74	0	67	252	923568	923383	Deinococcus aetherius ST0316 DNA, complete genome	blastn	218	267	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
17793316	17793316	PRJNA792582_P_NODE_54314_length_246_cov_1.531792_g53500_i0	PRJNA792582	54314	246	1.531792	3.76820832	Deinococcus	1298	Bacteria	Bacteria	300	7.19e-77	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g53500	i0	88.71	8.67073170731707	248	24	100	4	1	246	2217540	2217785	Deinococcus swuensis strain DY59, complete genome	blastn	2133	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
19903891	19903891	PRJNA792582_P_NODE_48696_length_253_cov_2.472222_g47882_i0	PRJNA792582	48696	253	2.472222	6.25472166	Deinococcus aetherius	200252	Bacteria	Bacteria	374	4.31e-99	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g47882	i0	93.281	19.0355731225296	253	17	100	0	1	253	2890384	2890636	Deinococcus aetherius ST0316 DNA, complete genome	blastn	4816	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
20341716	20341716	PRJNA792582_P_NODE_27336_length_330_cov_2.517510_g26522_i0	PRJNA792582	27336	330	2.51751	8.307783	Deinococcus	1298	Bacteria	Bacteria	479	1.1999999999999996e-130	NTclustered	gi\|485099143\|ref\|NR_102538.1\|	432329	g26522	i0	93.272	212.181818181818	327	19	98	3	1	325	531	856	Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence	blastn	70020	479	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
22454347	22454347	PRJNA792582_P_NODE_47758_length_256_cov_1.683060_g46944_i0	PRJNA792582	47758	256	1.68306	4.3086336	Deinococcus aetherius	200252	Bacteria	Bacteria	379	9.4e-101	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g46944	i0	93.359	3.00390625	256	17	100	0	1	256	1030346	1030091	Deinococcus aetherius ST0316 DNA, complete genome	blastn	769	379	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
22893162	22893162	PRJNA792582_P_NODE_49738_length_251_cov_0.865169_g48924_i0	PRJNA792582	49738	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	130	1.02e-25	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g48924	i0	78.922	4.84860557768924	204	33	79	8	53	251	2943177	2942979	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	1217	130	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
23730118	23730118	PRJNA792582_P_NODE_59599_length_241_cov_0.916667_g58785_i0	PRJNA792582	59599	241	0.916667	2.20916747	Deinococcus grandis	57498	Bacteria	Bacteria	178	3.43e-40	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g58785	i0	80.889	1.64730290456432	225	43	93	0	3	227	755722	755946	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	397	178	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
24166849	24166849	PRJNA792582_P_NODE_17379_length_413_cov_9.841176_g16565_i0	PRJNA792582	17379	413	9.841176	40.64405688	Deinococcus	1298	Bacteria	Bacteria	763	0	NTclustered	gi\|2678098150\|gb\|PP359631.1\|	47478	g16565	i0	100	103.823244552058	413	0	100	0	1	413	25	437	Deinococcus sp. strain BFCQ1 16S ribosomal RNA gene, partial sequence	blastn	42879	763	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;