metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax_phylum = "Chloroflexota"

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
275613	275613	PRJNA1120203_P_NODE_94721_length_245_cov_0.895349_g93705_i0	PRJNA1120203	94721	245	0.895349	2.19360505	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	82.4	2.82e-11	NTclustered	gi\|2814788335\|emb\|OY760861.2\|	3022862	g93705	i0	81.818	0.404081632653061	99	17	40	1	148	245	1009074	1008976	MAG: Tepidiformaceae bacterium isolate 815c9385-4915-413f-8b4b-d9ebc7d9cf62 genome assembly, chromosome: 1	blastn	99	82.4	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
275640	275640	PRJNA1120203_P_NODE_96841_length_244_cov_0.900585_g95825_i0	PRJNA1120203	96841	244	0.900585	2.1974274	Anaerolineales bacterium	2073117	Bacteria	Bacteria	364	2.489999999999999e-96	NTclustered	gi\|2108400823\|gb\|CP070639.1\|	2073117	g95825	i0	93.522	31.7131147540984	247	12	100	3	1	244	3336997	3336752	MAG: Anaerolineales bacterium isolate bin917 chromosome	blastn	7738	364	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
6652414	6652414	PRJNA1120203_P_NODE_104226_length_241_cov_0.916667_g103210_i0	PRJNA1120203	104226	241	0.916667	2.20916747	Candidatus Brevifilum fermentans	1986204	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1200880094\|emb\|LT859958.1\|	1986204	g103210	i0	100	1	241	0	100	0	1	241	1829069	1829309	Anaerolineaceae bacterium CAMBI-1 genome assembly, chromosome: I	blastn	241	446	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Candidatus Brevifilum	Candidatus Brevifilum fermentans
9203302	9203302	PRJNA1120203_P_NODE_79288_length_251_cov_0.865169_g78272_i0	PRJNA1120203	79288	251	0.865169	2.17157419	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	318	2.03e-82	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g78272	i0	89.6	82.3545816733068	250	26	99	0	1	250	457738	457987	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	20671	318	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9203581	9203581	PRJNA1120203_P_NODE_97608_length_244_cov_0.900585_g96592_i0	PRJNA1120203	97608	244	0.900585	2.1974274	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	156	1.63e-33	NTclustered	gi\|2621701201\|emb\|OY759723.1\|	2614250	g96592	i0	80.288	15.2213114754098	208	39	85	2	1	207	5094550	5094344	MAG: Caldilineaceae bacterium isolate cb27a3f3-5ea9-4825-a433-acfe24f43893 genome assembly, chromosome: 1	blastn	3714	156	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
11753770	11753770	PRJNA1120203_P_NODE_70930_length_266_cov_1.398964_g69914_i0	PRJNA1120203	70930	266	1.398964	3.72124424	Chloroflexota bacterium	2026724	Bacteria	Bacteria	243	1.34e-59	NTclustered	gi\|2108029441\|gb\|CP070764.1\|	2026724	g69914	i0	83.146	2.40977443609023	267	43	100	2	1	266	1373458	1373193	MAG: Chloroflexi bacterium isolate bin26 chromosome	blastn	641	243	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
13029128	13029128	PRJNA1120203_P_NODE_80851_length_250_cov_0.870056_g79835_i0	PRJNA1120203	80851	250	0.870056	2.17514	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	309	1.22e-79	NTclustered	gi\|2621704004\|emb\|OY762959.1\|	2026734	g79835	i0	89.641	1.004	251	15	96	5	11	250	2429981	2429731	MAG: Dehalococcoidia bacterium isolate a8fc5444-7059-4be1-bdcb-92646be6befe genome assembly, chromosome: 1	blastn	251	309	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
16852719	16852719	PRJNA1120203_P_NODE_84154_length_249_cov_0.875000_g83138_i0	PRJNA1120203	84154	249	0.875	2.17875	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	171	5.96e-38	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g83138	i0	82.979	72.2771084337349	188	32	76	0	62	249	2075375	2075188	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	17997	171	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18126987	18126987	PRJNA1120203_P_NODE_74055_length_259_cov_1.645161_g73039_i0	PRJNA1120203	74055	259	1.645161	4.26096699	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	95.3	3.86e-15	NTclustered	gi\|2531946085\|emb\|OY282385.1\|	498747	g73039	i0	84.946	7.6023166023166	93	14	36	0	2	94	1884693	1884601	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	1969	95.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
21951237	21951237	PRJNA1120203_P_NODE_102078_length_242_cov_0.911243_g101062_i0	PRJNA1120203	102078	242	0.911243	2.20520806	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	281	2.55e-71	NTclustered	gi\|2893358447\|emb\|OZ220739.1\|	3022862	g101062	i0	92	3.3801652892562	200	16	83	0	6	205	2500452	2500253	MAG: Tepidiformaceae bacterium isolate ddb3cf28-bb63-44a4-8fd1-08202229d10a genome assembly, chromosome: 1	blastn	818	281	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
23227819	23227819	PRJNA1120203_P_NODE_89039_length_247_cov_0.885057_g88023_i0	PRJNA1120203	89039	247	0.885057	2.18609079	Anaerolineales bacterium	2073117	Bacteria	Bacteria	171	5.91e-38	NTclustered	gi\|2320774688\|gb\|CP075527.1\|	2073117	g88023	i0	79.508	8.46963562753036	244	46	98	4	6	247	2134486	2134727	MAG: Anaerolineales bacterium isolate TGS_CHL4 chromosome	blastn	2092	171	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales 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);;