metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA690124" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA690124" 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
7047929	7047929	PRJNA690124_P_NODE_36186_length_276_cov_2.009852_g35820_i0	PRJNA690124	36186	276	2.009852	5.54719152	Trueperaceae bacterium	2026798	Bacteria	Bacteria	370	6.17e-98	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g35820	i0	92.941	463.514492753623	255	17	92	1	2	255	6527	6781	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	127930	370	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
8831708	8831708	PRJNA690124_P_NODE_56607_length_237_cov_2.603659_g56241_i0	PRJNA690124	56607	237	2.603659	6.17067183	Fervidobacterium	2422	Bacteria	Bacteria	433	6.5e-117	NTclustered	gi\|470489789\|ref\|NR_076950.1\|	93466	g56241	i0	99.578	92.8101265822785	237	1	100	0	1	237	1443	1679	Fervidobacterium pennivorans strain Ven5 23S ribosomal RNA gene, complete sequence	blastn	21996	433	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
10106990	10106990	PRJNA690124_P_NODE_22188_length_346_cov_1.274725_g21822_i0	PRJNA690124	22188	346	1.274725	4.4105485	Truepera	332248	Bacteria	Bacteria	442	1.6599999999999994e-119	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g21822	i0	89.655	90.0895953757225	348	34	100	1	1	346	1850	1503	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	31171	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
12148386	12148386	PRJNA690124_P_NODE_24830_length_329_cov_2.000000_g24464_i0	PRJNA690124	24830	329	2	6.58	Trueperaceae bacterium	2026798	Bacteria	Bacteria	414	3.43e-111	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g24464	i0	89.318	420.45896656535	337	27	100	4	1	329	3601162	3600827	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	138331	414	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
12148519	12148519	PRJNA690124_P_NODE_31610_length_294_cov_2.334842_g31244_i0	PRJNA690124	31610	294	2.334842	6.86443548	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	477	3.8e-130	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g31244	i0	95.44	48.4557823129252	307	1	100	1	1	294	1587219	1587525	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	14246	477	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
15207158	15207158	PRJNA690124_P_NODE_36992_length_274_cov_0.885572_g36626_i0	PRJNA690124	36992	274	0.885572	2.42646728	Deinococcus	1298	Bacteria	Bacteria	411	3.6e-110	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g36626	i0	94.717	259.412408759124	265	12	97	2	1	265	2148216	2147954	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	71079	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
17756342	17756342	PRJNA690124_P_NODE_32134_length_292_cov_1.392694_g31768_i0	PRJNA690124	32134	292	1.392694	4.06666648	Deinococcus	1298	Bacteria	Bacteria	534	2.1999999999999998e-147	NTclustered	gi\|2136551946\|gb\|MT672570.2\|	47478	g31768	i0	99.658	103.195205479452	292	1	100	0	1	292	64	355	Deinococcus sp. strain HSC-46F16 16S ribosomal RNA gene, partial sequence	blastn	30133	534	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
24895701	24895701	PRJNA690124_P_NODE_43820_length_253_cov_0.866667_g43454_i0	PRJNA690124	43820	253	0.866667	2.19266751	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	440	4.189999999999998e-119	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g43454	i0	98.024	1.99209486166008	253	5	100	0	1	253	1291799	1292051	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	504	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081

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