metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA529241" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA529241" 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
1775194	1775194	PRJNA529241_P_NODE_314862_length_173_cov_3.323529_g312540_i0	PRJNA529241	314862	173	3.323529	5.74970517	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	100	5.12e-17	NTclustered	gi\|2531948656\|emb\|OY282446.1\|	3022862	g312540	i0	95.238	12.3699421965318	63	3	36	0	98	160	1030204	1030266	MAG: Tepidiformaceae bacterium genome assembly, chromosome: 1	blastn	2140	100	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
1775334	1775334	PRJNA529241_P_NODE_332802_length_173_cov_3.117647_g330480_i0	PRJNA529241	332802	173	3.117647	5.39352931	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2531949168\|emb\|OY282456.1\|	498747	g330480	i0	96.97	0.352601156069364	33	1	19	0	116	148	2973448	2973416	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	61	56.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
1777079	1777079	PRJNA529241_P_NODE_534982_length_151_cov_3.359649_g532660_i0	PRJNA529241	534982	151	3.359649	5.07306999	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	91.6	2.61e-14	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g532660	i0	89.189	22.0596026490066	74	6	48	2	1	73	7760613	7760685	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	3331	91.6	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
1777113	1777113	PRJNA529241_P_NODE_539182_length_151_cov_3.236842_g536860_i0	PRJNA529241	539182	151	3.236842	4.88763142	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|2518540574\|emb\|OX638292.1\|	498747	g536860	i0	100	0.185430463576159	28	0	19	0	123	150	1929718	1929691	MAG: uncultured Dehalococcoidia bacterium isolate 695a8b18-9d85-47ae-89af-9793d4c73328 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
2391474	2391474	PRJNA529241_P_NODE_438522_length_161_cov_1.145161_g436200_i0	PRJNA529241	438522	161	1.145161	1.84370921	Chloroflexus	1107	Bacteria	Bacteria	254	3.42e-63	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g436200	i0	95.031	153.826086956522	161	8	100	0	1	161	1992	1832	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	24766	254	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
3049686	3049686	PRJNA529241_P_NODE_15203_length_604_cov_1.751323_g13201_i0	PRJNA529241	15203	604	1.751323	10.57799092	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	344	8.809999999999999e-90	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g13201	i0	81.532	136.341059602649	444	59	72	20	52	483	273637	273205	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	82350	344	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3050174	3050174	PRJNA529241_P_NODE_202743_length_173_cov_6.110294_g200421_i0	PRJNA529241	202743	173	6.110294	10.57080862	Anaerolineaceae bacterium oral taxon 439	1889813	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|1061024832\|gb\|CP017039.1\|	1889813	g200421	i0	83.237	1	173	10	100	1	1	173	12590	12743	Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome	blastn	173	141	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium oral taxon 439
3053048	3053048	PRJNA529241_P_NODE_565343_length_150_cov_5.362832_g563021_i0	PRJNA529241	565343	150	5.362832	8.044248	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.4	2.63e-4	NTclustered	gi\|2893358434\|emb\|OZ220726.1\|	2026724	g563021	i0	100	0.206666666666667	31	0	21	0	49	79	1233624	1233594	MAG: Chloroflexota bacterium isolate 6b50408d-bb21-410b-bf53-c761b53f873e genome assembly, chromosome: 1	blastn	31	58.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
6878726	6878726	PRJNA529241_P_NODE_443746_length_159_cov_1.090164_g441424_i0	PRJNA529241	443746	159	1.090164	1.73336076	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	58.4	2.83e-4	NTclustered	gi\|2893358390\|emb\|OZ220681.1\|	2026734	g441424	i0	97.059	4.90566037735849	34	1	22	0	38	71	2049758	2049791	MAG: Dehalococcoidia bacterium isolate b3870ce4-b2c0-4886-bd94-d5608d47d969 genome assembly, chromosome: 1	blastn	780	58.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
9427911	9427911	PRJNA529241_P_NODE_275748_length_173_cov_3.911765_g273426_i0	PRJNA529241	275748	173	3.911765	6.76735345	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	89.8	1.11e-13	NTclustered	gi\|2621703475\|emb\|OY762538.1\|	3022862	g273426	i0	89.189	4.36416184971098	74	5	41	2	103	173	362284	362211	MAG: Tepidiformaceae bacterium isolate 22918afd-2252-4b5b-9d47-9fe66d5d45bf genome assembly, chromosome: 1	blastn	755	89.8	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
11979114	11979114	PRJNA529241_P_NODE_367210_length_173_cov_2.691176_g364888_i0	PRJNA529241	367210	173	2.691176	4.65573448	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	76.8	8.62e-10	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g364888	i0	85.915	0.410404624277457	71	10	41	0	103	173	1893911	1893841	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	71	76.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11979249	11979249	PRJNA529241_P_NODE_382690_length_173_cov_2.544118_g380368_i0	PRJNA529241	382690	173	2.544118	4.40132414	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2531950174\|emb\|OY282494.1\|	498747	g380368	i0	100	0.323699421965318	28	0	16	0	98	125	1761754	1761781	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
13252098	13252098	PRJNA529241_P_NODE_116831_length_204_cov_9.125749_g114509_i0	PRJNA529241	116831	204	9.125749	18.61652796	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	80.5	8.16e-11	NTclustered	gi\|2531948656\|emb\|OY282446.1\|	3022862	g114509	i0	81.373	4.62745098039216	102	15	49	4	3	102	1741073	1740974	MAG: Tepidiformaceae bacterium genome assembly, chromosome: 1	blastn	944	80.5	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
15804775	15804775	PRJNA529241_P_NODE_573593_length_150_cov_4.212389_g571271_i0	PRJNA529241	573593	150	4.212389	6.3185835	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	75	2.61e-9	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g571271	i0	87.692	0.433333333333333	65	7	43	1	16	79	3492826	3492762	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	65	75	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15804799	15804799	PRJNA529241_P_NODE_576113_length_150_cov_3.938053_g573791_i0	PRJNA529241	576113	150	3.938053	5.9070795	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|2893358385\|emb\|OZ220679.1\|	2026734	g573791	i0	100	0.186666666666667	28	0	19	0	55	82	2428061	2428088	MAG: Dehalococcoidia bacterium isolate bff0dcbd-e965-4f93-bb55-57b6ceb5617d genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
18352827	18352827	PRJNA529241_P_NODE_473855_length_151_cov_8.307018_g471533_i0	PRJNA529241	473855	151	8.307018	12.54359718	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	89.8	9.39e-14	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g471533	i0	96.296	37.9602649006623	54	2	36	0	98	151	1908607	1908554	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	5732	89.8	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
18968250	18968250	PRJNA529241_P_NODE_73275_length_248_cov_1.668246_g70953_i0	PRJNA529241	73275	248	1.668246	4.13725008	Roseiflexus	120961	Bacteria	Bacteria	283	7.309999999999999e-72	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g70953	i0	92.079	14.5967741935484	202	15	81	1	48	248	605	806	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	3620	283	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
19626153	19626153	PRJNA529241_P_NODE_341216_length_173_cov_3.007353_g338894_i0	PRJNA529241	341216	173	3.007353	5.20272069	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	62.1	2.41e-5	NTclustered	gi\|2575803271\|emb\|OY729417.1\|	2026734	g338894	i0	100	0.543352601156069	33	0	19	0	42	74	2036666	2036634	MAG: Dehalococcoidia bacterium isolate 7d10fddc-660b-4070-a7a7-cda0dfc66286 genome assembly, chromosome: 1	blastn	94	62.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20901548	20901548	PRJNA529241_P_NODE_232397_length_173_cov_4.897059_g230075_i0	PRJNA529241	232397	173	4.897059	8.47191207	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	102	1.42e-17	NTclustered	gi\|2893358376\|emb\|OZ220670.1\|	2026734	g230075	i0	100	46.0057803468208	55	0	32	0	119	173	666414	666360	MAG: Dehalococcoidia bacterium isolate 3214a3e4-8eac-45e1-a090-ccf36b200536 genome assembly, chromosome: 1	blastn	7959	102	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20904281	20904281	PRJNA529241_P_NODE_578077_length_150_cov_3.752212_g575755_i0	PRJNA529241	578077	150	3.752212	5.628318	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	71.3	3.37e-8	NTclustered	gi\|2891482386\|emb\|OZ220076.1\|	2026734	g575755	i0	93.617	9.25333333333333	47	3	31	0	104	150	60710	60756	MAG: Dehalococcoidia bacterium isolate 04bbb1fd-b304-46d8-a6aa-ea4a1f3e4c6b genome assembly, chromosome: 21	blastn	1388	71.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
21518018	21518018	PRJNA529241_P_NODE_438497_length_161_cov_1.201613_g436175_i0	PRJNA529241	438497	161	1.201613	1.93459693	Herpetosiphon	64	Bacteria	Bacteria	134	4.64e-27	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g436175	i0	93.333	4.31055900621118	90	6	56	0	72	161	1651	1740	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	694	134	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
23452757	23452757	PRJNA529241_P_NODE_388559_length_173_cov_2.448529_g386237_i0	PRJNA529241	388559	173	2.448529	4.23595517	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	71.3	4.01e-8	NTclustered	gi\|2626282194\|emb\|OY839116.1\|	2026734	g386237	i0	86.154	0.375722543352601	65	9	38	0	1	65	3131629	3131565	MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1	blastn	65	71.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
24728433	24728433	PRJNA529241_P_NODE_77560_length_242_cov_4.185366_g75238_i0	PRJNA529241	77560	242	4.185366	10.12858572	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	102	2.13e-17	NTclustered	gi\|2621704692\|emb\|OY762063.1\|	2026734	g75238	i0	89.286	114.285123966942	84	5	36	4	4	86	1414094	1414014	MAG: Dehalococcoidia bacterium isolate 5405c63e-44e1-4988-9b68-fe709a885d54 genome assembly, chromosome: 1	blastn	27657	102	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia 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);;