metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA1111082" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA1111082" and tax_clade = "FCB group"

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
2765891	2765891	PRJNA1111082_P_NODE_10383_length_253_cov_0.866667_g10338_i0	PRJNA1111082	10383	253	0.866667	2.19266751	Phocaeicola vulgatus	821	Bacteria	Bacteria	388	1.5399999999999998e-103	NTclustered	gi\|2916523787\|gb\|CP181423.1\|	821	g10338	i0	94.466	138.699604743083	253	13	100	1	1	253	5017136	5017387	Phocaeicola vulgatus strain sJLG0017 chromosome, complete genome	blastn	35091	388	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
2765904	2765904	PRJNA1111082_P_NODE_10823_length_251_cov_0.876404_g10778_i0	PRJNA1111082	10823	251	0.876404	2.19977404	Rufibacter sp. DG15C	1379909	Bacteria	Bacteria	87.9	6.24e-13	NTclustered	gi\|1001988277\|gb\|CP010776.1\|	1379909	g10778	i0	73.643	1.02788844621514	258	54	100	11	1	251	854525	854275	Rufibacter sp. DG15C, complete genome	blastn	258	87.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Rufibacter	Rufibacter sp. DG15C
2765911	2765911	PRJNA1111082_P_NODE_11103_length_249_cov_1.625000_g11058_i0	PRJNA1111082	11103	249	1.625	4.04625	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	263	9.56e-66	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g11058	i0	85.83	76.6947791164659	247	35	99	0	3	249	4458012	4458258	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	19097	263	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4042058	4042058	PRJNA1111082_P_NODE_12044_length_245_cov_0.906977_g11999_i0	PRJNA1111082	12044	245	0.906977	2.22209365	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	261	3.38e-65	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g11999	i0	87.179	1.9469387755102	234	24	95	5	12	243	98961	98732	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	477	261	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5318255	5318255	PRJNA1111082_P_NODE_4545_length_368_cov_1.318644_g4500_i0	PRJNA1111082	4545	368	1.318644	4.85260992	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	586	7.75e-163	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g4500	i0	95.393	16.508152173913	369	15	100	2	1	368	478771	478404	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	6075	586	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
6593576	6593576	PRJNA1111082_P_NODE_8746_length_275_cov_1.158416_g8701_i0	PRJNA1111082	8746	275	1.158416	3.185644	Runella sp. SP2	2268026	Bacteria	Bacteria	464	2.7399999999999998e-126	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g8701	i0	97.091	1	275	8	100	0	1	275	2228935	2229209	Runella sp. SP2 chromosome, complete genome	blastn	275	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
7868012	7868012	PRJNA1111082_P_NODE_12427_length_243_cov_0.917647_g12382_i0	PRJNA1111082	12427	243	0.917647	2.22988221	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	202	2.0599999999999995e-47	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g12382	i0	82.7	0.975308641975309	237	32	98	7	3	239	1018823	1019050	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	237	202	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9142885	9142885	PRJNA1111082_P_NODE_12028_length_245_cov_0.906977_g11983_i0	PRJNA1111082	12028	245	0.906977	2.22209365	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	252	2.0299999999999998e-62	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g11983	i0	86.463	2.57142857142857	229	31	93	0	17	245	3862120	3861892	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	630	252	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10418677	10418677	PRJNA1111082_P_NODE_11009_length_250_cov_0.881356_g10964_i0	PRJNA1111082	11009	250	0.881356	2.20339	Flavobacterium limnophilum	3003262	Bacteria	Bacteria	124	4.729999999999999e-24	NTclustered	gi\|2477668611\|gb\|CP114289.2\|	3003262	g10964	i0	89.109	0.404	101	10	40	1	1	100	224825	224725	Flavobacterium limnophilum strain IMCC36791 chromosome, complete genome	blastn	101	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium limnophilum
10418833	10418833	PRJNA1111082_P_NODE_4869_length_356_cov_3.918728_g4824_i0	PRJNA1111082	4869	356	3.918728	13.95067168	Bacteroides ovatus	28116	Bacteria	Bacteria	658	0	NTclustered	gi\|2032952970\|gb\|CP072244.1\|	28116	g4824	i0	100	22.6376404494382	356	0	100	0	1	356	5082741	5082386	Bacteroides ovatus strain CL06T03C20 chromosome, complete genome	blastn	8059	658	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides ovatus
11694084	11694084	PRJNA1111082_P_NODE_7230_length_300_cov_2.255507_g7185_i0	PRJNA1111082	7230	300	2.255507	6.766521	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	520	6.36e-143	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g7185	i0	98.007	2.00666666666667	301	3	100	3	1	300	2503618	2503320	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	602	520	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
11694121	11694121	PRJNA1111082_P_NODE_8670_length_276_cov_1.251232_g8625_i0	PRJNA1111082	8670	276	1.251232	3.45340032	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	259	1.39e-64	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g8625	i0	88.732	3.91666666666667	213	22	77	2	1	213	2405973	2406183	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	1081	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
12969299	12969299	PRJNA1111082_P_NODE_6891_length_307_cov_1.000000_g6846_i0	PRJNA1111082	6891	307	1	3.07	Runella sp. SP2	2268026	Bacteria	Bacteria	518	2.35e-142	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g6846	i0	97.068	1	307	9	100	0	1	307	2230249	2230555	Runella sp. SP2 chromosome, complete genome	blastn	307	518	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
14244063	14244063	PRJNA1111082_P_NODE_11052_length_250_cov_0.881356_g11007_i0	PRJNA1111082	11052	250	0.881356	2.20339	Hymenobacter baengnokdamensis	2615203	Bacteria	Bacteria	263	9.61e-66	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g11007	i0	86.555	0.952	238	32	95	0	1	238	17948	18185	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	238	263	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
14244092	14244092	PRJNA1111082_P_NODE_12232_length_244_cov_0.912281_g12187_i0	PRJNA1111082	12232	244	0.912281	2.22596564	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	200	7.4299999999999985e-47	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g12187	i0	91.667	0.590163934426229	144	12	59	0	1	144	865039	865182	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	144	200	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16792408	16792408	PRJNA1111082_P_NODE_12674_length_242_cov_0.923077_g12629_i0	PRJNA1111082	12674	242	0.923077	2.23384634	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	206	1.58e-48	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g12629	i0	88.068	1.33057851239669	176	18	71	3	5	177	1622167	1621992	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	322	206	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18066853	18066853	PRJNA1111082_P_NODE_10055_length_256_cov_1.595628_g10010_i0	PRJNA1111082	10055	256	1.595628	4.08480768	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	200	7.85e-47	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g10010	i0	81.857	1.8515625	237	43	93	0	19	255	1373490	1373254	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	474	200	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
18066861	18066861	PRJNA1111082_P_NODE_1055_length_668_cov_0.991597_g1012_i0	PRJNA1111082	1055	668	0.991597	6.62386796	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	1179	0	NTclustered	gi\|2119748049\|dbj\|AP025183.1\|	1751056	g1012	i0	98.503	3.95359281437126	668	10	100	0	1	668	876613	875946	Flavobacterium ammonificans GENT11 DNA, complete genome	blastn	2641	1179	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
19341113	19341113	PRJNA1111082_P_NODE_11456_length_247_cov_1.793103_g11411_i0	PRJNA1111082	11456	247	1.793103	4.42896441	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g11411	i0	100	29.6437246963563	247	0	100	0	1	247	873026	873272	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	7322	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
19341139	19341139	PRJNA1111082_P_NODE_12696_length_242_cov_0.923077_g12651_i0	PRJNA1111082	12696	242	0.923077	2.23384634	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	82.4	2.78e-11	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g12651	i0	87.5	0.297520661157025	72	8	29	1	97	167	3775024	3775095	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	72	82.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19341186	19341186	PRJNA1111082_P_NODE_2736_length_459_cov_4.318653_g2691_i0	PRJNA1111082	2736	459	4.318653	19.82261727	Lewinella sp. LCG006	3231911	Bacteria	Bacteria	322	3.07e-83	NTclustered	gi\|2773055173\|gb\|CP160680.1\|	3231911	g2691	i0	79.872	478.241830065359	467	73	99	20	1	457	792403	792858	Lewinella sp. LCG006 chromosome, complete genome	blastn	219513	322	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Lewinellaceae	Lewinella	Lewinella sp. LCG006
19341370	19341370	PRJNA1111082_P_NODE_8956_length_271_cov_2.954545_g8911_i0	PRJNA1111082	8956	271	2.954545	8.00681695	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	425	1.27e-114	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g8911	i0	97.581	2.45756457564576	248	6	92	0	24	271	581444	581197	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	666	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
20616383	20616383	PRJNA1111082_P_NODE_10717_length_251_cov_1.567416_g10672_i0	PRJNA1111082	10717	251	1.567416	3.93421416	Flavobacterium sp. N2820	2986834	Bacteria	Bacteria	283	7.409999999999999e-72	NTclustered	gi\|2324023843\|gb\|CP110008.1\|	2986834	g10672	i0	88.462	61.3266932270916	234	27	93	0	1	234	2968693	2968460	Flavobacterium sp. N2820 chromosome, complete genome	blastn	15393	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2820
22698186	22698186	PRJNA1111082_P_NODE_10398_length_253_cov_0.866667_g10353_i0	PRJNA1111082	10398	253	0.866667	2.19266751	Flavobacterium	237	Bacteria	Bacteria	71.3	6.34e-8	NTclustered	gi\|2496343437\|gb\|CP092332.1\|	1306518	g10353	i0	90.741	0.391304347826087	54	4	21	1	127	179	1489994	1489941	Flavobacterium keumense strain K3R-10 chromosome, complete genome	blastn	99	71.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium keumense
23167751	23167751	PRJNA1111082_P_NODE_6319_length_318_cov_1.155102_g6274_i0	PRJNA1111082	6319	318	1.155102	3.67322436	Aquirufa antheringensis	2516559	Bacteria	Bacteria	337	7.35e-88	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g6274	i0	90.837	2.12264150943396	251	23	99	0	65	315	450738	450988	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	675	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
24441159	24441159	PRJNA1111082_P_NODE_12040_length_245_cov_0.906977_g11995_i0	PRJNA1111082	12040	245	0.906977	2.22209365	Hymenobacter yonginensis	748197	Bacteria	Bacteria	174	4.52e-39	NTclustered	gi\|2423912131\|gb\|CP115396.1\|	748197	g11995	i0	79.839	7.01224489795918	248	42	99	8	1	244	3732774	3733017	Hymenobacter yonginensis strain KCTC 22745 chromosome, complete genome	blastn	1718	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter yonginensis

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