metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA939370" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA939370" 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
914627	914627	PRJNA939370_S_NODE_2581_length_172_cov_0.845528_g2529_i0	PRJNA939370	2581	172	0.845528	1.45430816	Trueperaceae bacterium	2026798	Bacteria	Bacteria	207	2.91e-49	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g2529	i0	91.892	5.86046511627907	148	12	86	0	24	171	9426	9573	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	1008	207	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
1256161	1256161	PRJNA939370_S_NODE_2941_length_165_cov_1.094828_g2889_i0	PRJNA939370	2941	165	1.094828	1.8064662	Fervidobacterium	2422	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|61657861\|emb\|AJ876542.1\|	2424	g2889	i0	98.788	48.3757575757576	165	2	100	0	1	165	191	355	Fervidobacterium nodosum partial 23S rRNA gene	blastn	7982	294	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
3808172	3808172	PRJNA939370_S_NODE_1203_length_253_cov_1.872549_g1151_i0	PRJNA939370	1203	253	1.872549	4.73754897	Fervidobacterium	2422	Bacteria	Bacteria	411	3.2899999999999995e-110	NTclustered	gi\|61657861\|emb\|AJ876542.1\|	2424	g1151	i0	98.283	127.897233201581	233	4	92	0	21	253	1458	1226	Fervidobacterium nodosum partial 23S rRNA gene	blastn	32358	411	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
3808183	3808183	PRJNA939370_S_NODE_2123_length_188_cov_1.208633_g2071_i0	PRJNA939370	2123	188	1.208633	2.27223004	Deinococcus	1298	Bacteria	Bacteria	239	1.15e-58	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g2071	i0	91.379	158.420212765957	174	15	93	0	15	188	1478	1651	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	29783	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
5084456	5084456	PRJNA939370_S_NODE_1484_length_225_cov_1.971591_g1432_i0	PRJNA939370	1484	225	1.971591	4.43607975	Fervidobacterium	2422	Bacteria	Bacteria	401	1.7199999999999994e-107	NTclustered	gi\|806984310\|ref\|NG_042008.1\|	2424	g1432	i0	100	280.848888888889	217	0	96	0	2	218	2127	2343	Fervidobacterium nodosum strain Rt17-B1 23S ribosomal RNA gene, complete sequence	blastn	63191	401	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
15284071	15284071	PRJNA939370_S_NODE_1352_length_237_cov_2.696809_g1300_i0	PRJNA939370	1352	237	2.696809	6.39143733	root	1	Root_unresolved	Root_unresolved	411	3.049999999999999e-110	NTclustered	gi\|444439378\|ref\|NR_074093.1\|	2424	g1300	i0	99.556	102.514767932489	225	1	95	0	1	225	513	737	Fervidobacterium nodosum strain Rt17-B1 16S ribosomal RNA, partial sequence	blastn	24296	411	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
20382472	20382472	PRJNA939370_S_NODE_2936_length_165_cov_1.155172_g2884_i0	PRJNA939370	2936	165	1.155172	1.9060338	Deinococcus	1298	Bacteria	Bacteria	278	2.09e-70	NTclustered	gi\|189305297\|gb\|EU704886.1\|	158789	g2884	i0	96.97	108	165	5	100	0	1	165	854	690	Uncultured Deinococcus sp. clone 1P-1-M01 16S ribosomal RNA gene, partial sequence	blastn	17820	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
22933987	22933987	PRJNA939370_S_NODE_2858_length_166_cov_1.042735_g2806_i0	PRJNA939370	2858	166	1.042735	1.7309401	Fervidobacterium	2422	Bacteria	Bacteria	289	9.729999999999999e-74	NTclustered	gi\|61657861\|emb\|AJ876542.1\|	2424	g2806	i0	98.182	59.6807228915663	165	3	99	0	2	166	1020	856	Fervidobacterium nodosum partial 23S rRNA gene	blastn	9907	289	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
22933989	22933989	PRJNA939370_S_NODE_2998_length_164_cov_1.486957_g2946_i0	PRJNA939370	2998	164	1.486957	2.43860948	Fervidobacterium	2422	Bacteria	Bacteria	231	1.6399999999999998e-56	NTclustered	gi\|444439378\|ref\|NR_074093.1\|	2424	g2946	i0	98.473	89.7256097560976	131	2	80	0	7	137	344	214	Fervidobacterium nodosum strain Rt17-B1 16S ribosomal RNA, partial sequence	blastn	14715	231	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
24207738	24207738	PRJNA939370_S_NODE_239_length_550_cov_1.319361_g191_i0	PRJNA939370	239	550	1.319361	7.2564855	Deinococcus	1298	Bacteria	Bacteria	778	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g191	i0	92.224	206.1	553	38	100	3	1	550	2417451	2418001	Deinococcus sp. NW-56 chromosome, complete genome	blastn	113355	778	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56

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