metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1011844" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1011844" 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
3982863	3982863	PRJNA1011844_P_NODE_159604_length_242_cov_1.508876_g151024_i0	PRJNA1011844	159604	242	1.508876	3.65147992	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	311	3.26e-80	NTclustered	gi\|2891482139\|emb\|OZ219872.1\|	2026734	g151024	i0	90.987	249.45041322314	233	18	95	3	3	233	448496	448727	MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 6	blastn	60367	311	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
5258636	5258636	PRJNA1011844_P_NODE_109265_length_304_cov_3.796537_g100691_i0	PRJNA1011844	109265	304	3.796537	11.54147248	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2531949176\|emb\|OY282458.1\|	498747	g100691	i0	100	0.0921052631578947	28	0	9	0	105	132	486868	486895	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
7808943	7808943	PRJNA1011844_P_NODE_161247_length_241_cov_1.446429_g152667_i0	PRJNA1011844	161247	241	1.446429	3.48589389	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	396	8.7e-106	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g152667	i0	97.817	301.211618257261	229	5	95	0	3	231	3032137	3032365	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	72592	396	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9084069	9084069	PRJNA1011844_P_NODE_171868_length_226_cov_2.509804_g163287_i0	PRJNA1011844	171868	226	2.509804	5.67215704	Anaerolineales bacterium	2073117	Bacteria	Bacteria	337	4.9599999999999994e-88	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g163287	i0	94.884	209.637168141593	215	11	95	0	12	226	2029421	2029207	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	47378	337	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
11635901	11635901	PRJNA1011844_P_NODE_54670_length_575_cov_7.021912_g46340_i0	PRJNA1011844	54670	575	7.021912	40.375994	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	54.7	0.016	NTclustered	gi\|2531949168\|emb\|OY282456.1\|	498747	g46340	i0	96.875	0.0556521739130435	32	1	6	0	257	288	1662667	1662698	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
12910462	12910462	PRJNA1011844_P_NODE_28851_length_986_cov_9.238773_g22325_i0	PRJNA1011844	28851	986	9.238773	91.09430178	Anaerolineae bacterium	2052143	Bacteria	Bacteria	62.1	1.66e-4	NTclustered	gi\|1879344079\|gb\|CP059258.1\|	2052143	g22325	i0	94.872	0.118661257606491	39	2	4	0	172	210	2188140	2188102	MAG: Anaerolineae bacterium isolate SSC4 chromosome	blastn	117	62.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
14184651	14184651	PRJNA1011844_P_NODE_133252_length_265_cov_3.869792_g124674_i0	PRJNA1011844	133252	265	3.869792	10.2549488	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g124674	i0	100	0.109433962264151	29	0	11	0	57	85	10808350	10808322	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
14185062	14185062	PRJNA1011844_P_NODE_167092_length_233_cov_2.237500_g158511_i0	PRJNA1011844	167092	233	2.2375	5.213375	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	281	2.44e-71	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g158511	i0	89.908	189.064377682403	218	22	94	0	1	218	2202366	2202583	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	44052	281	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
14185947	14185947	PRJNA1011844_P_NODE_54412_length_578_cov_3.762376_g46088_i0	PRJNA1011844	54412	578	3.762376	21.74653328	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	60.2	3.41e-4	NTclustered	gi\|2531948664\|emb\|OY282448.1\|	166587	g46088	i0	94.737	0.0657439446366782	38	2	7	0	466	503	2522631	2522594	MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1	blastn	38	60.2	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
14186413	14186413	PRJNA1011844_P_NODE_85092_length_377_cov_31.875000_g76546_i0	PRJNA1011844	85092	377	31.875	120.16875	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|2893358447\|emb\|OZ220739.1\|	3022862	g76546	i0	100	0.0742705570291777	28	0	7	0	258	285	1951976	1951949	MAG: Tepidiformaceae bacterium isolate ddb3cf28-bb63-44a4-8fd1-08202229d10a genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
21834174	21834174	PRJNA1011844_P_NODE_52278_length_601_cov_2.195076_g43987_i0	PRJNA1011844	52278	601	2.195076	13.19240676	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g43987	i0	100	0.0482529118136439	29	0	5	0	472	500	159801	159773	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
23108645	23108645	PRJNA1011844_P_NODE_155239_length_245_cov_0.895349_g146659_i0	PRJNA1011844	155239	245	0.895349	2.19360505	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	134	7.68e-27	NTclustered	gi\|2891482381\|emb\|OZ220071.1\|	2026734	g146659	i0	82.993	0.6	147	25	60	0	89	235	75936	75790	MAG: Dehalococcoidia bacterium isolate 04bbb1fd-b304-46d8-a6aa-ea4a1f3e4c6b genome assembly, chromosome: 16	blastn	147	134	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
23108695	23108695	PRJNA1011844_P_NODE_159759_length_242_cov_1.035503_g151179_i0	PRJNA1011844	159759	242	1.035503	2.50591726	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	335	1.9299999999999993e-87	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g151179	i0	93.074	63.0702479338843	231	12	95	4	4	232	1028123	1027895	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	15263	335	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23109987	23109987	PRJNA1011844_P_NODE_74699_length_426_cov_6.373938_g66203_i0	PRJNA1011844	74699	426	6.373938	27.15297588	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	67.6	1.47e-6	NTclustered	gi\|2621704926\|emb\|OY762213.1\|	2026734	g66203	i0	100	5.17370892018779	36	0	8	0	130	165	216044	216009	MAG: Dehalococcoidia bacterium isolate 03469a5e-dcd7-4577-8116-c1a2ee551a24 genome assembly, chromosome: 1	blastn	2204	67.6	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
24381788	24381788	PRJNA1011844_P_NODE_108880_length_305_cov_3.439655_g100307_i0	PRJNA1011844	108880	305	3.439655	10.49094775	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2531948664\|emb\|OY282448.1\|	166587	g100307	i0	100	0.0918032786885246	28	0	9	0	188	215	1084039	1084012	MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
25227896	25227896	PRJNA1011844_P_NODE_106160_length_310_cov_4.409283_g97587_i0	PRJNA1011844	106160	310	4.409283	13.6687773	Herpetosiphon	64	Bacteria	Bacteria	122	2.1799999999999999e-23	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g97587	i0	83.582	29.4096774193548	134	19	43	3	175	307	434	565	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	9117	122	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus

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