metadata: contig_metadata: 18 rows where bioproject = "PRJNA665531" and tax

18 rows where bioproject = "PRJNA665531" 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
5732767	5732767	PRJNA665531_P_NODE_15825_length_260_cov_1.556150_g15589_i0	PRJNA665531	15825	260	1.55615	4.04599	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	350	7.5e-92	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g15589	i0	91.732	35.0269230769231	254	17	99	4	2	254	68585	68835	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	9107	350	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
5732824	5732824	PRJNA665531_P_NODE_18005_length_247_cov_0.885057_g17769_i0	PRJNA665531	18005	247	0.885057	2.18609079	Deinococcus metallilatus	1211322	Bacteria	Bacteria	267	7.32e-67	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g17769	i0	86.179	16.7813765182186	246	34	99	0	2	247	2337700	2337945	Deinococcus metallilatus strain MA1002 chromosome	blastn	4145	267	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
6266162	6266162	PRJNA665531_P_NODE_765_length_1285_cov_5.850660_g674_i0	PRJNA665531	765	1285	5.85066	75.180981	Deinococcus	1298	Bacteria	Bacteria	2276	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g674	i0	98.602	352.356420233463	1288	15	100	3	1	1285	68968	70255	Deinococcus swuensis strain DY59, complete genome	blastn	452778	2276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
7007967	7007967	PRJNA665531_P_NODE_17406_length_249_cov_1.681818_g17170_i0	PRJNA665531	17406	249	1.681818	4.18772682	Truepera radiovictrix	332249	Bacteria	Bacteria	120	1.22e-29	NR	WP_148221269.1	332249	g17170	i0	74.7	1	83	20	98.8	1	3	248	354	436	WP_148221269.1 N-acetylmuramoyl-L-alanine amidase family protein [Truepera radiovictrix]	diamond	249	120	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
9557912	9557912	PRJNA665531_P_NODE_2228_length_775_cov_2.717949_g2030_i0	PRJNA665531	2228	775	2.717949	21.06410475	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	833	0	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g2030	i0	87.145	92.1767741935484	739	89	97	6	34	769	70155	69420	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	71437	833	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
10833489	10833489	PRJNA665531_P_NODE_18629_length_244_cov_0.900585_g18393_i0	PRJNA665531	18629	244	0.900585	2.1974274	uncultured Truepera sp.	543023	Bacteria	Bacteria	137	6.45e-36	NR	CAA9560764.1	543023	g18393	i0	88.8	0.983606557377049	80	9	98.4	0	3	242	199	278	CAA9560764.1 MAG: D-3-phosphoglycerate dehydrogenase [uncultured Truepera sp.]	diamond	240	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
12108543	12108543	PRJNA665531_P_NODE_11830_length_302_cov_1.257642_g11594_i0	PRJNA665531	11830	302	1.257642	3.79807884	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	453	6.6e-123	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g11594	i0	93.709	316.655629139073	302	19	100	0	1	302	69242	68941	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	95630	453	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
15190826	15190826	PRJNA665531_P_NODE_13792_length_279_cov_1.495146_g13556_i0	PRJNA665531	13792	279	1.495146	4.17145734	Truepera	332248	Bacteria	Bacteria	82.4	3.28e-11	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g13556	i0	91.525	0.587813620071685	59	5	21	0	221	279	1059544	1059486	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	164	82.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
16465139	16465139	PRJNA665531_P_NODE_1853_length_860_cov_4.606099_g1668_i0	PRJNA665531	1853	860	4.606099	39.6124514	Deinococcus	1298	Bacteria	Bacteria	1251	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g1668	i0	93.31	200.08488372093	852	49	98	7	15	860	70503	69654	Deinococcus swuensis strain DY59, complete genome	blastn	172073	1251	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
17740170	17740170	PRJNA665531_P_NODE_14274_length_274_cov_2.333333_g14038_i0	PRJNA665531	14274	274	2.333333	6.39333242	Thermus	270	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|1955386990\|dbj\|AP024305.1\|	274	g14038	i0	100	136.007299270073	274	0	100	0	1	274	353158	352885	Thermus thermophilus HB5008 DNA, complete genome	blastn	37266	507	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
25388746	25388746	PRJNA665531_P_NODE_18600_length_244_cov_1.350877_g18364_i0	PRJNA665531	18600	244	1.350877	3.29613988	Truepera	332248	Bacteria	Bacteria	237	5.6600000000000005e-58	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g18364	i0	84.362	1.94262295081967	243	36	99	2	1	242	286469	286228	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	474	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
26828461	26828461	PRJNA665531_P_NODE_17541_length_249_cov_0.875000_g17305_i0	PRJNA665531	17541	249	0.875	2.17875	Truepera radiovictrix	332249	Bacteria	Bacteria	129	5.86e-34	NR	WP_013178476.1	332249	g17305	i0	81.5	0.975903614457831	81	15	97.6	0	2	244	163	243	WP_013178476.1 alpha-E domain-containing protein [Truepera radiovictrix]	diamond	243	129	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
26860309	26860309	PRJNA665531_P_NODE_18221_length_246_cov_0.890173_g17985_i0	PRJNA665531	18221	246	0.890173	2.18982558	Truepera radiovictrix	332249	Bacteria	Bacteria	79	1.06e-15	NR	WP_013178902.1	332249	g17985	i0	62.9	0.75609756097561	62	23	75.6	0	55	240	3	64	WP_013178902.1 HAD family hydrolase [Truepera radiovictrix]	diamond	186	79	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
27555200	27555200	PRJNA665531_P_NODE_17044_length_251_cov_0.865169_g16808_i0	PRJNA665531	17044	251	0.865169	2.17157419	Deinococcota bacterium	1913990	Bacteria	Bacteria	105	1.75e-24	NR	MEM7736472.1	1913990	g16808	i0	57.8	1.9840637450199201	83	35	99.2	0	250	2	365	447	MEM7736472.1 FAD-binding oxidoreductase [Deinococcota bacterium]	diamond	498	105	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
28344723	28344723	PRJNA665531_P_NODE_16186_length_257_cov_1.396739_g15950_i0	PRJNA665531	16186	257	1.396739	3.58961923	Meiothermus sp.	1955249	Bacteria	Bacteria	128	1.19e-34	NR	MDX2008499.1	1955249	g15950	i0	75.3	1.98443579766537	85	21	99.2	0	3	257	105	189	MDX2008499.1 ferric reductase-like transmembrane domain-containing protein [Meiothermus sp.]	diamond	510	128	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp.
31978012	31978012	PRJNA665531_P_NODE_18898_length_243_cov_0.905882_g18662_i0	PRJNA665531	18898	243	0.905882	2.20129326	Truepera radiovictrix	332249	Bacteria	Bacteria	47	0.00112	NR	WP_013178521.1	332249	g18662	i0	56.4	0.962962962962963	39	17	48.1	0	2	118	294	332	WP_013178521.1 nitrilase-related carbon-nitrogen hydrolase [Truepera radiovictrix]	diamond	234	47	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
32326504	32326504	PRJNA665531_P_NODE_17039_length_251_cov_0.865169_g16803_i0	PRJNA665531	17039	251	0.865169	2.17157419	uncultured Truepera sp.	543023	Bacteria	Bacteria	94	1.3e-20	NR	CAA9579596.1	543023	g16803	i0	62.1	1.0398406374502	87	28	99.2	2	1	249	224	309	CAA9579596.1 MAG: Glycine betaine/L-proline transport ATP-binding protein ProV [uncultured Truepera sp.]	diamond	261	94	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
32831114	32831114	PRJNA665531_P_NODE_17260_length_250_cov_0.870056_g17024_i0	PRJNA665531	17260	250	0.870056	2.17514	Trueperaceae bacterium	2026798	Bacteria	Bacteria	119	3.6e-30	NR	HEX7021279.1	2026798	g17024	i0	69.5	2.976	82	25	98.4	0	1	246	124	205	HEX7021279.1 cysteine desulfurase family protein [Trueperaceae bacterium]	diamond	744	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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);;