metadata: contig_metadata: 8 rows where bioproject = "PRJEB48872" and tax

8 rows where bioproject = "PRJEB48872" 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
990847	990847	PRJEB48872_P_NODE_80881_length_754_cov_2.082517_g66573_i0	PRJEB48872	80881	754	2.082517	15.70217818	Truepera	332248	Bacteria	Bacteria	638	4.5599999999999994e-178	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g66573	i0	90.121	259.59151193634	496	41	99	7	1	492	1741	1250	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	195732	638	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
6093954	6093954	PRJEB48872_P_NODE_684545_length_152_cov_1.610619_g668733_i0	PRJEB48872	684545	152	1.610619	2.44814088	Truepera	332248	Bacteria	Bacteria	209	6.97e-50	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g668733	i0	91.447	173.138157894737	152	13	100	0	1	152	501	350	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	26317	209	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
11194039	11194039	PRJEB48872_P_NODE_480489_length_200_cov_1.198758_g464677_i0	PRJEB48872	480489	200	1.198758	2.397516	Truepera	332248	Bacteria	Bacteria	254	4.44e-63	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g464677	i0	89.5	380.52	200	21	100	0	1	200	530	729	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	76104	254	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
11559630	11559630	PRJEB48872_P_NODE_500970_length_193_cov_2.305195_g485158_i0	PRJEB48872	500970	193	2.305195	4.44902635	Deinococcus gobiensis	502394	Bacteria	Bacteria	357	3.1499999999999996e-94	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g485158	i0	100	295.886010362694	193	0	100	0	1	193	112042	111850	Deinococcus gobiensis I-0, complete genome	blastn	57106	357	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
14110456	14110456	PRJEB48872_P_NODE_515112_length_189_cov_2.033333_g499300_i0	PRJEB48872	515112	189	2.033333	3.84299937	Kosmotoga pacifica	1330330	Bacteria	Bacteria	161	2.5799999999999996e-35	NTclustered	gi\|827411924\|gb\|CP011232.1\|	1330330	g499300	i0	86.486	80.5820105820106	148	18	77	2	43	188	537494	537641	Kosmotoga pacifica strain SLHLJ1, complete genome	blastn	15230	161	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Kosmotoga	Kosmotoga pacifica
15018494	15018494	PRJEB48872_P_NODE_402812_length_229_cov_1.873684_g387000_i0	PRJEB48872	402812	229	1.873684	4.29073636	Deinococcus	1298	Bacteria	Bacteria	401	1.7599999999999995e-107	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g387000	i0	98.253	202.135371179039	229	4	100	0	1	229	2148547	2148319	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	46289	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
28265091	28265091	PRJEB48872_P_NODE_409286_length_226_cov_2.272727_g393474_i0	PRJEB48872	409286	226	2.272727	5.13636302	Synergistaceae bacterium	2053624	Bacteria	Bacteria	58.2	1.06e-7	NR	MDR1873727.1	2053624	g393474	i0	74.2	0.823008849557522	31	8	41.2	0	93	1	1	31	MDR1873727.1 AAA family ATPase [Synergistaceae bacterium]	diamond	186	58.2	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29244117	29244117	PRJEB48872_P_NODE_290169_length_294_cov_6.290196_g274357_i0	PRJEB48872	290169	294	6.290196	18.49317624	Thermotogota bacterium	2053689	Bacteria	Bacteria	43.1	0.0159	NR	MDY6895075.1	2053689	g274357	i0	38.9	0.73469387755102	72	31	73.5	4	26	241	24	82	MDY6895075.1 ADP-ribosylglycohydrolase family protein [Thermotogota bacterium]	diamond	216	43.1	1	Bacteria	Thermotogati	Thermotogota					Thermotogota 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);;