metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA688655" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA688655" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
667146	667146	PRJNA688655_P_NODE_16081_length_241_cov_0.916667_g16016_i0	PRJNA688655	16081	241	0.916667	2.20916747	Leptolinea sp. HRD-7	2830982	Bacteria	Bacteria	176	1.23e-39	NTclustered	gi\|2250018340\|dbj\|AP024710.1\|	2830982	g16016	i0	81.395	14.8921161825726	215	40	89	0	2	216	290248	290462	Leptolinea sp. HRD-7 DNA, complete genome	blastn	3589	176	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Leptolinea	Leptolinea sp. HRD-7
1943246	1943246	PRJNA688655_P_NODE_9902_length_249_cov_0.875000_g9837_i0	PRJNA688655	9902	249	0.875	2.17875	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	60.2	1.35e-4	NTclustered	gi\|2893358376\|emb\|OZ220670.1\|	2026734	g9837	i0	97.143	0.140562248995984	35	1	14	0	137	171	341311	341345	MAG: Dehalococcoidia bacterium isolate 3214a3e4-8eac-45e1-a090-ccf36b200536 genome assembly, chromosome: 1	blastn	35	60.2	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
3218154	3218154	PRJNA688655_P_NODE_9943_length_249_cov_0.875000_g9878_i0	PRJNA688655	9943	249	0.875	2.17875	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	122	1.69e-23	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g9878	i0	83.704	24.6465863453815	135	17	53	3	14	144	789805	789672	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	6137	122	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4495080	4495080	PRJNA688655_P_NODE_13184_length_245_cov_0.895349_g13119_i0	PRJNA688655	13184	245	0.895349	2.19360505	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	171	5.85e-38	NTclustered	gi\|2893358404\|emb\|OZ220695.1\|	3022862	g13119	i0	88.112	66.0530612244898	143	17	58	0	1	143	126137	125995	MAG: Tepidiformaceae bacterium isolate d5d77930-af5a-4506-8b4e-3340c6a42e1f genome assembly, chromosome: 1	blastn	16183	171	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
5770831	5770831	PRJNA688655_P_NODE_6725_length_265_cov_1.140625_g6660_i0	PRJNA688655	6725	265	1.140625	3.02265625	Candidatus Brevifilum fermentans	1986204	Bacteria	Bacteria	479	9.38e-131	NTclustered	gi\|1200880094\|emb\|LT859958.1\|	1986204	g6660	i0	99.245	1	265	2	100	0	1	265	1071899	1072163	Anaerolineaceae bacterium CAMBI-1 genome assembly, chromosome: I	blastn	265	479	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Candidatus Brevifilum	Candidatus Brevifilum fermentans
9595664	9595664	PRJNA688655_P_NODE_12248_length_246_cov_0.890173_g12183_i0	PRJNA688655	12248	246	0.890173	2.18982558	Anaerolineales bacterium	2073117	Bacteria	Bacteria	178	3.5099999999999993e-40	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g12183	i0	91.473	1.54065040650407	129	11	52	0	3	131	66882	66754	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	379	178	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
10871241	10871241	PRJNA688655_P_NODE_4089_length_315_cov_1.272727_g4024_i0	PRJNA688655	4089	315	1.272727	4.00909005	Dehalococcoides sp. THU4	3348344	Bacteria	Bacteria	433	9.01e-117	NTclustered	gi\|2832821058\|gb\|CP171266.1\|	3348344	g4024	i0	91.429	3.57460317460317	315	27	100	0	1	315	552482	552796	Dehalococcoides sp. THU4 chromosome	blastn	1126	433	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalococcoides	Dehalococcoides sp. THU4
10871275	10871275	PRJNA688655_P_NODE_6729_length_265_cov_1.031250_g6664_i0	PRJNA688655	6729	265	1.03125	2.7328125	Candidatus Brevifilum fermentans	1986204	Bacteria	Bacteria	399	7.509999999999999e-107	NTclustered	gi\|1200880094\|emb\|LT859958.1\|	1986204	g6664	i0	93.962	2.00377358490566	265	15	100	1	1	265	1039024	1039287	Anaerolineaceae bacterium CAMBI-1 genome assembly, chromosome: I	blastn	531	399	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Candidatus Brevifilum	Candidatus Brevifilum fermentans
13421121	13421121	PRJNA688655_P_NODE_2291_length_379_cov_1.006536_g2226_i0	PRJNA688655	2291	379	1.006536	3.81477144	Dehalococcoides mccartyi	61435	Bacteria	Bacteria	259	1.98e-64	NTclustered	gi\|2904237995\|gb\|CP179927.1\|	61435	g2226	i0	79.156	1.9868073878628	379	76	99	2	1	376	923352	922974	MAG: Dehalococcoides mccartyi isolate NK chromosome, complete genome	blastn	753	259	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalococcoides	Dehalococcoides mccartyi
15969782	15969782	PRJNA688655_P_NODE_11453_length_247_cov_0.885057_g11388_i0	PRJNA688655	11453	247	0.885057	2.18609079	Anaerolineales bacterium	2073117	Bacteria	Bacteria	158	4.6e-34	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g11388	i0	78.601	0.983805668016194	243	48	98	4	7	247	1540902	1541142	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	243	158	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
15969816	15969816	PRJNA688655_P_NODE_13753_length_244_cov_0.900585_g13688_i0	PRJNA688655	13753	244	0.900585	2.1974274	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	158	4.53e-34	NTclustered	gi\|2814788344\|emb\|OY760098.2\|	2952883	g13688	i0	80.882	3.82786885245902	204	35	83	4	5	206	1834329	1834530	MAG: Aggregatilineales bacterium isolate 38e3f777-17bf-4c24-a9d7-54fd166e8adf genome assembly, chromosome: 1	blastn	934	158	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
15969951	15969951	PRJNA688655_P_NODE_8613_length_250_cov_0.870056_g8548_i0	PRJNA688655	8613	250	0.870056	2.17514	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	207	4.57e-49	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g8548	i0	82.979	6.552	235	34	93	6	4	235	10869897	10869666	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	1638	207	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18519291	18519291	PRJNA688655_P_NODE_6715_length_265_cov_1.203125_g6650_i0	PRJNA688655	6715	265	1.203125	3.18828125	Candidatus Brevifilum fermentans	1986204	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|1200880094\|emb\|LT859958.1\|	1986204	g6650	i0	100	1	265	0	100	0	1	265	1057224	1056960	Anaerolineaceae bacterium CAMBI-1 genome assembly, chromosome: I	blastn	265	490	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Candidatus Brevifilum	Candidatus Brevifilum fermentans
18519297	18519297	PRJNA688655_P_NODE_6915_length_262_cov_1.222222_g6850_i0	PRJNA688655	6915	262	1.222222	3.20222164	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	167	8.18e-37	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g6850	i0	79.032	32.2671755725191	248	48	94	4	4	249	298911	299156	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	8454	167	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21069513	21069513	PRJNA688655_P_NODE_11377_length_247_cov_0.885057_g11312_i0	PRJNA688655	11377	247	0.885057	2.18609079	Anaerolineae bacterium	2052143	Bacteria	Bacteria	202	2.0899999999999999e-47	NTclustered	gi\|2107864099\|gb\|CP070818.1\|	2052143	g11312	i0	83.036	0.906882591093117	224	36	90	2	25	247	1861197	1860975	MAG: Anaerolineae bacterium isolate bin1159 chromosome	blastn	224	202	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
21579111	21579111	PRJNA688655_P_NODE_16477_length_241_cov_0.916667_g16412_i0	PRJNA688655	16477	241	0.916667	2.20916747	Chloroflexus	1107	Bacteria	Bacteria	99	2.75e-16	NTclustered	gi\|219541215\|gb\|CP001337.1\|	326427	g16412	i0	87.209	1.85477178423237	86	11	36	0	25	110	3991100	3991015	Chloroflexus aggregans DSM 9485, complete genome	blastn	447	100	0.99	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
22344456	22344456	PRJNA688655_P_NODE_14538_length_243_cov_0.905882_g14473_i0	PRJNA688655	14538	243	0.905882	2.20129326	Candidatus Brevifilum fermentans	1986204	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1200880094\|emb\|LT859958.1\|	1986204	g14473	i0	100	1	243	0	100	0	1	243	1060111	1059869	Anaerolineaceae bacterium CAMBI-1 genome assembly, chromosome: I	blastn	243	449	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Candidatus Brevifilum	Candidatus Brevifilum fermentans
24893205	24893205	PRJNA688655_P_NODE_10600_length_248_cov_0.880000_g10535_i0	PRJNA688655	10600	248	0.88	2.1824	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	206	1.6299999999999998e-48	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g10535	i0	85.641	1.05645161290323	195	28	79	0	20	214	2556369	2556563	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	262	206	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
24893241	24893241	PRJNA688655_P_NODE_12720_length_245_cov_0.895349_g12655_i0	PRJNA688655	12720	245	0.895349	2.19360505	Anaerolineales bacterium	2073117	Bacteria	Bacteria	285	2.0000000000000002e-72	NTclustered	gi\|2320772474\|gb\|CP075526.1\|	2073117	g12655	i0	88.017	95.7142857142857	242	27	98	2	5	245	1662215	1661975	MAG: Anaerolineales bacterium isolate TGS_CHL3 chromosome	blastn	23450	285	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
24893299	24893299	PRJNA688655_P_NODE_1640_length_432_cov_0.857939_g1575_i0	PRJNA688655	1640	432	0.857939	3.70629648	Candidatus Brevifilum fermentans	1986204	Bacteria	Bacteria	798	0	NTclustered	gi\|1200880094\|emb\|LT859958.1\|	1986204	g1575	i0	100	1	432	0	100	0	1	432	1074329	1073898	Anaerolineaceae bacterium CAMBI-1 genome assembly, chromosome: I	blastn	432	798	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Candidatus Brevifilum	Candidatus Brevifilum fermentans

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