metadata: contig_metadata: 17 rows where bioproject = "PRJNA1034994" and tax

17 rows where bioproject = "PRJNA1034994" 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
2282780	2282780	PRJNA1034994_P_NODE_542_length_722_cov_3.020031_g461_i0	PRJNA1034994	542	722	3.020031	21.80462382	Deinococcus	1298	Bacteria	Bacteria	1016	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g461	i0	92.265	193.076177285319	724	44	100	9	1	722	2341168	2341881	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	139401	1016	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
3558168	3558168	PRJNA1034994_P_NODE_403_length_844_cov_4.625162_g330_i0	PRJNA1034994	403	844	4.625162	39.03636728	Deinococcus	1298	Bacteria	Bacteria	1535	0	NTclustered	gi\|1142915234\|gb\|KX832182.1\|	47478	g330	i0	99.761	138.986966824645	838	0	99	1	7	844	1	836	Deinococcus sp. strain 311:FR1_AP2_32 16S ribosomal RNA gene, partial sequence	blastn	117305	1541	0.99610642439974	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
3994776	3994776	PRJNA1034994_P_NODE_3764_length_284_cov_1.146919_g3680_i0	PRJNA1034994	3764	284	1.146919	3.2572499600000002	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g3680	i0	99.648	1	284	1	100	0	1	284	1065881	1065598	Thermus sp. NEB1569 chromosome, complete genome	blastn	284	520	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
3994804	3994804	PRJNA1034994_P_NODE_7384_length_249_cov_0.875000_g7300_i0	PRJNA1034994	7384	249	0.875	2.17875	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	342	1.1899999999999999e-89	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g7300	i0	91.837	27.8152610441767	245	20	98	0	5	249	1289501	1289257	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	6926	342	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
6546319	6546319	PRJNA1034994_P_NODE_9026_length_244_cov_0.900585_g8942_i0	PRJNA1034994	9026	244	0.900585	2.1974274	Deinococcus ficus	317577	Bacteria	Bacteria	233	7.319999999999999e-57	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g8942	i0	85.526	4.99180327868852	228	27	92	6	14	238	1437296	1437520	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	1218	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
7820896	7820896	PRJNA1034994_P_NODE_5627_length_261_cov_2.377660_g5543_i0	PRJNA1034994	5627	261	2.37766	6.2056926	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	244	3.66e-60	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g5543	i0	83.588	21.1072796934866	262	41	100	2	1	261	69686	69946	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	5509	244	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
8660711	8660711	PRJNA1034994_P_NODE_467_length_788_cov_2.268531_g392_i0	PRJNA1034994	467	788	2.268531	17.87602428	Deinococcus	1298	Bacteria	Bacteria	1190	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g392	i0	93.836	212.215736040609	795	41	100	6	1	788	423331	424124	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	167226	1190	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
10371521	10371521	PRJNA1034994_P_NODE_8929_length_244_cov_2.461988_g8845_i0	PRJNA1034994	8929	244	2.461988	6.00725072	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	346	9.019999999999999e-91	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g8845	i0	92.531	202.073770491803	241	18	99	0	4	244	544326	544086	Deinococcus sp. NW-56 chromosome, complete genome	blastn	49306	346	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
14196850	14196850	PRJNA1034994_P_NODE_1612_length_399_cov_2.450920_g1528_i0	PRJNA1034994	1612	399	2.45092	9.7791708	Deinococcus apachensis	309886	Bacteria	Bacteria	549	1.1099999999999999e-151	NTclustered	gi\|413911378\|gb\|KC113139.1\|	309886	g1528	i0	92.072	111.050125313283	391	30	98	1	8	398	390	1	Deinococcus apachensis strain KSI 1117 16S ribosomal RNA gene, partial sequence	blastn	44309	549	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus apachensis
15035235	15035235	PRJNA1034994_P_NODE_4832_length_270_cov_2.969543_g4748_i0	PRJNA1034994	4832	270	2.969543	8.0177661	Truepera	332248	Bacteria	Bacteria	355	1.6799999999999996e-93	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g4748	i0	90.406	113.659259259259	271	25	100	1	1	270	1823	1553	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	30688	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
16745215	16745215	PRJNA1034994_P_NODE_8754_length_245_cov_0.895349_g8670_i0	PRJNA1034994	8754	245	0.895349	2.19360505	Deinococcus yunweiensis	367282	Bacteria	Bacteria	246	9.449999999999999e-61	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g8670	i0	84.836	10.5551020408163	244	37	99	0	2	245	3423832	3424075	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	2586	246	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
18859231	18859231	PRJNA1034994_P_NODE_6015_length_257_cov_1.673913_g5931_i0	PRJNA1034994	6015	257	1.673913	4.30195641	Truepera	332248	Bacteria	Bacteria	272	1.65e-68	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g5931	i0	86.345	16.3813229571984	249	34	97	0	1	249	3169282	3169530	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	4210	272	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
19294060	19294060	PRJNA1034994_P_NODE_5816_length_260_cov_0.919786_g5732_i0	PRJNA1034994	5816	260	0.919786	2.3914436	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	339	1.62e-88	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g5732	i0	90.494	316.65	263	15	99	9	3	260	68900	68643	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	82329	339	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
20133988	20133988	PRJNA1034994_P_NODE_816_length_577_cov_2.825397_g733_i0	PRJNA1034994	816	577	2.825397	16.30254069	Deinococcus	1298	Bacteria	Bacteria	815	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g733	i0	92.15	351.027729636049	586	32	100	12	1	577	594	14	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	202543	821	0.992691839220463	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
20569403	20569403	PRJNA1034994_P_NODE_4477_length_275_cov_1.138614_g4393_i0	PRJNA1034994	4477	275	1.138614	3.1311885	Deinococcus aquaticus	328692	Bacteria	Bacteria	398	2.8199999999999996e-106	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g4393	i0	92.727	4	275	20	100	0	1	275	961953	962227	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	1100	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
21845155	21845155	PRJNA1034994_P_NODE_7398_length_249_cov_0.875000_g7314_i0	PRJNA1034994	7398	249	0.875	2.17875	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	215	2.72e-51	NTclustered	gi\|1339790005\|gb\|CP026518.1\|	2080419	g7314	i0	83.7	13.0160642570281	227	37	91	0	1	227	200186	200412	Deinococcus sp. NW-56 plasmid unnamed2, complete sequence	blastn	3241	215	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
29908941	29908941	PRJNA1034994_P_NODE_5251_length_266_cov_1.186528_g5167_i0	PRJNA1034994	5251	266	1.186528	3.15616448	Truepera radiovictrix	332249	Bacteria	Bacteria	44.3	0.0132	NR	WP_013178081.1	332249	g5167	i0	94.7	0.214285714285714	19	1	21.4	0	4	60	312	330	WP_013178081.1 YsnF/AvaK domain-containing protein [Truepera radiovictrix]	diamond	57	44.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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