metadata: contig_metadata: 15 rows where bioproject = "PRJEB41113" and tax

15 rows where bioproject = "PRJEB41113" 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
6092981	6092981	PRJEB41113_S_NODE_1765_length_232_cov_126.517949_g1756_i0	PRJEB41113	1765	232	126.517949	293.52164168	Truepera	332248	Bacteria	Bacteria	298	2.41e-76	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g1756	i0	93.103	402.39224137931	203	14	88	0	30	232	214	12	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	93355	298	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
10261923	10261923	PRJEB41113_S_NODE_1909_length_229_cov_1.510417_g1900_i0	PRJEB41113	1909	229	1.510417	3.45885493	root	1	Root_unresolved	Root_unresolved	147	6.28e-39	NR	1TAQ_A	271	g1900	i0	100	4.91266375545852	75	0	98.3	0	226	2	418	492	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1125	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
17910672	17910672	PRJEB41113_S_NODE_1655_length_236_cov_4.376884_g1646_i0	PRJEB41113	1655	236	4.376884	10.32944624	Bacteria	2	Bacteria	Bacteria	147	6.83e-39	NR	1TAQ_A	271	g1646	i0	98.7	2.97457627118644	78	1	99.2	0	235	2	718	795	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	702	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
19184635	19184635	PRJEB41113_S_NODE_2636_length_213_cov_4.090909_g2627_i0	PRJEB41113	2636	213	4.090909	8.71363617	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	156	1.39e-33	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g2627	i0	83.041	5.50234741784038	171	29	80	0	37	207	1409347	1409517	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	1172	156	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
20459981	20459981	PRJEB41113_S_NODE_3057_length_207_cov_1.876471_g3048_i0	PRJEB41113	3057	207	1.876471	3.88429497	Deinococcus koreensis	2054903	Bacteria	Bacteria	372	1.2199999999999997e-98	NTclustered	gi\|1232994349\|gb\|MF669554.1\|	2054903	g3048	i0	99.034	115.217391304348	207	2	100	0	1	207	410	204	Deinococcus koreensis strain SJW1-2 16S ribosomal RNA gene, partial sequence	blastn	23850	372	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus koreensis
27191370	27191370	PRJEB41113_S_NODE_11042_length_157_cov_1.916667_g11033_i0	PRJEB41113	11042	157	1.916667	3.00916719	Truepera radiovictrix	332249	Bacteria	Bacteria	96.7	1.19e-21	NR	WP_148221273.1	332249	g11033	i0	80.4	0.974522292993631	51	10	97.5	0	5	157	397	447	WP_148221273.1 glutamine--tRNA ligase/YqeY domain fusion protein [Truepera radiovictrix]	diamond	153	96.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
27279755	27279755	PRJEB41113_S_NODE_12343_length_154_cov_2.111111_g12334_i0	PRJEB41113	12343	154	2.111111	3.25111094	root	1	Root_unresolved	Root_unresolved	100	6.909999999999999e-23	NR	1TAQ_A	271	g12334	i0	100	5.96103896103896	51	0	99.4	0	154	2	489	539	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	918	100	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
27343110	27343110	PRJEB41113_S_NODE_523_length_302_cov_8.916981_g514_i0	PRJEB41113	523	302	8.916981	26.92928262	Bacteria	2	Bacteria	Bacteria	212	3.82e-62	NR	1TAQ_A	271	g514	i0	100	3.97350993377483	100	0	99.3	0	3	302	142	241	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1200	212	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
27879672	27879672	PRJEB41113_S_NODE_465_length_309_cov_17.643382_g456_i0	PRJEB41113	465	309	17.643382	54.51805038	Bacteria	2	Bacteria	Bacteria	188	3.25e-53	NR	1TAQ_A	271	g456	i0	100	5.57281553398058	96	0	93.2	0	3	290	37	132	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1722	188	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
28612568	28612568	PRJEB41113_S_NODE_3227_length_204_cov_3.952096_g3218_i0	PRJEB41113	3227	204	3.952096	8.06227584	Thermus sp. LT1-2-5	3026935	Bacteria	Bacteria	51.6	1.65e-5	NR	WP_353512010.1	3026935	g3218	i0	53.1	5.70588235294118	64	22	86.8	2	185	9	765	825	WP_353512010.1 hypothetical protein [Thermus sp. LT1-2-5]	diamond	1164	51.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. LT1-2-5
28928255	28928255	PRJEB41113_S_NODE_2808_length_210_cov_7.699422_g2799_i0	PRJEB41113	2808	210	7.699422	16.1687862	Truepera radiovictrix	332249	Bacteria	Bacteria	58.2	8.44e-8	NR	WP_013178712.1	332249	g2799	i0	48.4	1.82857142857143	64	33	91.4	0	209	18	53	116	WP_013178712.1 DUF418 domain-containing protein [Truepera radiovictrix]	diamond	384	58.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
29212619	29212619	PRJEB41113_S_NODE_15369_length_150_cov_1.893805_g15360_i0	PRJEB41113	15369	150	1.893805	2.8407075	Truepera radiovictrix	332249	Bacteria	Bacteria	60.1	7.6e-9	NR	WP_013176585.1	332249	g15360	i0	69.4	0.98	49	15	98	0	148	2	127	175	WP_013176585.1 bifunctional glutamate N-acetyltransferase/amino-acid acetyltransferase ArgJ [Truepera radiovictrix]	diamond	147	60.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
29464627	29464627	PRJEB41113_S_NODE_11750_length_155_cov_2.779661_g11741_i0	PRJEB41113	11750	155	2.779661	4.30847455	Truepera radiovictrix	332249	Bacteria	Bacteria	78.6	2.61e-15	NR	WP_013179263.1	332249	g11741	i0	68	0.967741935483871	50	16	96.8	0	3	152	585	634	WP_013179263.1 cytochrome c oxidase subunit I [Truepera radiovictrix]	diamond	150	78.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
32625685	32625685	PRJEB41113_S_NODE_4420_length_191_cov_4.740260_g4411_i0	PRJEB41113	4420	191	4.74026	9.0538966	Synergistaceae bacterium	2053624	Bacteria	Bacteria	93.6	1.53e-20	NR	MFA7219030.1	2053624	g4411	i0	79.6	0.769633507853403	49	10	77	0	2	148	334	382	MFA7219030.1 WGR domain-containing protein [Synergistaceae bacterium]	diamond	147	93.6	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32713574	32713574	PRJEB41113_S_NODE_3120_length_206_cov_1.473373_g3111_i0	PRJEB41113	3120	206	1.473373	3.03514838	Bacteria	2	Bacteria	Bacteria	130	2.22e-33	NR	1TAQ_A	271	g3111	i0	98.4	3.72815533980583	64	1	93.2	0	204	13	647	710	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	768	130	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus

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