metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA900028" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA900028" 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
874539	874539	PRJNA900028_P_NODE_124601_length_167_cov_0.864407_g123852_i0	PRJNA900028	124601	167	0.864407	1.44355969	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	93.5	8.25e-15	NTclustered	gi\|2621704841\|emb\|OY763089.1\|	2026734	g123852	i0	92.308	3.59281437125748	65	5	39	0	1	65	602788	602852	MAG: Dehalococcoidia bacterium isolate e66569de-989e-459c-8942-bbbb2819a0b0 genome assembly, chromosome: 1	blastn	600	93.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
874928	874928	PRJNA900028_P_NODE_16281_length_291_cov_1.223140_g15532_i0	PRJNA900028	16281	291	1.22314	3.5593374	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	399	8.359999999999999e-107	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g15532	i0	92.473	445.862542955326	279	21	96	0	1	279	564964	565242	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	129746	399	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
1245324	1245324	PRJNA900028_P_NODE_43141_length_216_cov_1.826347_g42392_i0	PRJNA900028	43141	216	1.826347	3.94490952	Herpetosiphon	64	Bacteria	Bacteria	368	1.67e-97	NTclustered	gi\|1783321\|emb\|X86447.1\|	71864	g42392	i0	97.664	100.064814814815	214	5	99	0	3	216	979	1192	Herpetosiphon sp. 16S rRNA gene	blastn	21614	368	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon sp.
2150093	2150093	PRJNA900028_P_NODE_155382_length_164_cov_0.886957_g154633_i0	PRJNA900028	155382	164	0.886957	1.45460948	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	165	1.69e-36	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g154633	i0	85.897	0.951219512195122	156	20	95	2	3	157	465631	465785	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	156	165	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4704476	4704476	PRJNA900028_P_NODE_67304_length_190_cov_1.595745_g66555_i0	PRJNA900028	67304	190	1.595745	3.0319155	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	174	3.34e-39	NTclustered	gi\|2893358456\|emb\|OZ220748.1\|	2026734	g66555	i0	93.913	86.3	115	7	61	0	62	176	2908290	2908176	MAG: Dehalococcoidia bacterium isolate 6c7b36c8-b3ab-4b4c-a352-7e98d29eb5d7 genome assembly, chromosome: 1	blastn	16397	174	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
4704570	4704570	PRJNA900028_P_NODE_76304_length_186_cov_2.204380_g75555_i0	PRJNA900028	76304	186	2.20438	4.1001468	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	230	6.839999999999999e-56	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g75555	i0	89.189	96.2688172043011	185	19	99	1	1	184	1027977	1028161	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	17906	230	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5978325	5978325	PRJNA900028_P_NODE_178365_length_162_cov_0.902655_g177616_i0	PRJNA900028	178365	162	0.902655	1.4623011	Anaerolineaceae bacterium oral taxon 439	1889813	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|1061024832\|gb\|CP017039.1\|	1889813	g177616	i0	99.383	1	162	1	100	0	1	162	718778	718939	Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome	blastn	162	294	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium oral taxon 439
7252553	7252553	PRJNA900028_P_NODE_118586_length_167_cov_1.296610_g117837_i0	PRJNA900028	118586	167	1.29661	2.1653387	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2891482391\|emb\|OZ220081.1\|	2026734	g117837	i0	92.308	0.233532934131737	39	1	23	2	113	150	2092	2129	MAG: Dehalococcoidia bacterium isolate 04bbb1fd-b304-46d8-a6aa-ea4a1f3e4c6b genome assembly, chromosome: 26	blastn	39	54.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
8528991	8528991	PRJNA900028_P_NODE_93127_length_179_cov_1.230769_g92378_i0	PRJNA900028	93127	179	1.230769	2.20307651	Anaerolineaceae bacterium oral taxon 439	1889813	Bacteria	Bacteria	329	6.26e-86	NTclustered	gi\|1061024832\|gb\|CP017039.1\|	1889813	g92378	i0	100	1.20111731843575	178	0	99	0	1	178	2247691	2247514	Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome	blastn	215	329	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium oral taxon 439
9802490	9802490	PRJNA900028_P_NODE_133888_length_166_cov_0.871795_g133139_i0	PRJNA900028	133888	166	0.871795	1.4471797	Anaerolineaceae bacterium oral taxon 439	1889813	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1061024832\|gb\|CP017039.1\|	1889813	g133139	i0	100	1	166	0	100	0	1	166	1214740	1214905	Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome	blastn	166	307	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium oral taxon 439
9804056	9804056	PRJNA900028_P_NODE_92648_length_179_cov_1.569231_g91899_i0	PRJNA900028	92648	179	1.569231	2.80892349	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2518551288\|emb\|OX638345.1\|	498747	g91899	i0	100	0.156424581005587	28	0	16	0	89	116	1296677	1296704	MAG: uncultured Dehalococcoidia bacterium isolate 64bd3295-a2ac-4bb0-a587-f708157bf7f0 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
9804119	9804119	PRJNA900028_P_NODE_98308_length_176_cov_2.070866_g97559_i0	PRJNA900028	98308	176	2.070866	3.64472416	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	231	1.78e-56	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g97559	i0	92.547	5.72159090909091	161	12	91	0	7	167	1858967	1859127	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	1007	231	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12354745	12354745	PRJNA900028_P_NODE_63850_length_193_cov_1.416667_g63101_i0	PRJNA900028	63850	193	1.416667	2.73416731	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	230	7.159999999999998e-56	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g63101	i0	88.482	7.43523316062176	191	20	98	1	1	189	2828980	2828790	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	1435	230	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
13629277	13629277	PRJNA900028_P_NODE_38011_length_224_cov_1.165714_g37262_i0	PRJNA900028	38011	224	1.165714	2.61119936	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	202	1.87e-47	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g37262	i0	83.186	60.375	226	32	99	6	2	224	2828201	2827979	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	13524	202	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
14903612	14903612	PRJNA900028_P_NODE_54072_length_203_cov_1.324675_g53323_i0	PRJNA900028	54072	203	1.324675	2.68909025	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	285	1.6e-72	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g53323	i0	92.079	17.2857142857143	202	16	99	0	1	202	2827750	2827549	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	3509	285	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
17452985	17452985	PRJNA900028_P_NODE_151074_length_165_cov_0.879310_g150325_i0	PRJNA900028	151074	165	0.87931	1.4508615	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	137	3.7e-28	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g150325	i0	86.4	155.284848484848	125	17	76	0	1	125	547	423	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	25622	137	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
18726051	18726051	PRJNA900028_P_NODE_135575_length_166_cov_0.871795_g134826_i0	PRJNA900028	135575	166	0.871795	1.4471797	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	220	3.6e-53	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g134826	i0	90.854	1.98192771084337	164	15	99	0	3	166	1963416	1963579	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	329	220	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22551628	22551628	PRJNA900028_P_NODE_153978_length_164_cov_1.260870_g153229_i0	PRJNA900028	153978	164	1.26087	2.0678268	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	228	2.1199999999999996e-55	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g153229	i0	91.975	101.932926829268	162	13	99	0	3	164	3290871	3290710	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	16717	228	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23827197	23827197	PRJNA900028_P_NODE_173219_length_163_cov_0.894737_g172470_i0	PRJNA900028	173219	163	0.894737	1.45842131	Anaerolineales bacterium	2073117	Bacteria	Bacteria	111	2.21e-20	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g172470	i0	79.012	1.62576687116564	162	34	99	0	1	162	2926782	2926621	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	265	111	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
25100700	25100700	PRJNA900028_P_NODE_143640_length_165_cov_0.879310_g142891_i0	PRJNA900028	143640	165	0.87931	1.4508615	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	121	3.73e-23	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g142891	i0	80.368	0.987878787878788	163	28	97	3	6	165	3490743	3490904	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	163	121	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
25102047	25102047	PRJNA900028_P_NODE_83000_length_183_cov_2.283582_g82251_i0	PRJNA900028	83000	183	2.283582	4.17895506	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	246	6.659999999999999e-61	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g82251	i0	90.86	129.191256830601	186	13	100	4	1	183	566550	566366	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	23642	246	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia 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);;