metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA867519" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA867519" 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
848056	848056	PRJNA867519_P_NODE_18501_length_282_cov_1.473684_g18347_i0	PRJNA867519	18501	282	1.473684	4.15578888	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	226	1.4499999999999998e-54	NTclustered	gi\|2556922676\|gb\|CP129488.1\|	2202734	g18347	i0	81.443	177.109929078014	291	40	100	13	1	282	3058851	3059136	MAG: Saprospiraceae bacterium isolate cMAG.8 chromosome, complete genome	blastn	49945	226	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
848139	848139	PRJNA867519_P_NODE_29381_length_246_cov_1.693642_g29227_i0	PRJNA867519	29381	246	1.693642	4.16635932	Fibrella aestuarina	651143	Bacteria	Bacteria	353	5.44e-93	NTclustered	gi\|384064804\|emb\|HE796683.1\|	1166018	g29227	i0	92.683	262.747967479675	246	17	99	1	1	245	610973	610728	Fibrella aestuarina BUZ 2 drat genome	blastn	64636	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrella	Fibrella aestuarina
1236988	1236988	PRJNA867519_P_NODE_29721_length_246_cov_0.890173_g29567_i0	PRJNA867519	29721	246	0.890173	2.18982558	Emticicia	312278	Bacteria	Bacteria	381	2.5e-101	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g29567	i0	94.715	234.59756097561	246	11	100	2	1	246	381	138	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	57711	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
4676436	4676436	PRJNA867519_P_NODE_12424_length_329_cov_1.667969_g12270_i0	PRJNA867519	12424	329	1.667969	5.48761801	uncultured Ferruginibacter sp.	1042239	Bacteria	Bacteria	520	7.059999999999998e-143	NTclustered	gi\|2575820297\|emb\|OY730416.1\|	1042239	g12270	i0	95.137	253.808510638298	329	16	100	0	1	329	3394033	3393705	MAG: uncultured Ferruginibacter sp. isolate 52100660-89e0-41f3-aa4d-b5ad2bee9e90 genome assembly, chromosome: 1	blastn	83503	520	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	uncultured Ferruginibacter sp.
5065031	5065031	PRJNA867519_P_NODE_15244_length_302_cov_1.681223_g15090_i0	PRJNA867519	15244	302	1.681223	5.07729346	Emticicia	312278	Bacteria	Bacteria	523	4.9599999999999983e-144	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g15090	i0	98.013	336.235099337748	302	4	100	2	1	302	1530	1829	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	101543	523	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
7226394	7226394	PRJNA867519_P_NODE_33466_length_241_cov_0.916667_g33312_i0	PRJNA867519	33466	241	0.916667	2.20916747	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2518552101\|emb\|OX638356.1\|	2910168	g33312	i0	100	0.116182572614108	28	0	12	0	72	99	3082417	3082390	MAG: Longimicrobiales bacterium isolate 11c1aa9f-90ef-4017-a54d-d6b2e11378d8 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
8500897	8500897	PRJNA867519_P_NODE_10267_length_354_cov_4.836299_g10113_i0	PRJNA867519	10267	354	4.836299	17.12049846	Sphingobacterium mizutaii	1010	Bacteria	Bacteria	654	0	NTclustered	gi\|1231743971\|emb\|LT906468.1\|	1010	g10113	i0	100	437.838983050847	354	0	100	0	1	354	1278073	1278426	Sphingobacterium mizutaii strain NCTC12149 genome assembly, chromosome: 1	blastn	154995	654	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium mizutaii
9776205	9776205	PRJNA867519_P_NODE_8188_length_388_cov_2.441270_g8034_i0	PRJNA867519	8188	388	2.44127	9.4721276	Runella sp. SP2	2268026	Bacteria	Bacteria	695	0	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g8034	i0	98.969	262.128865979381	388	4	100	0	1	388	5734674	5735061	Runella sp. SP2 chromosome, complete genome	blastn	101706	695	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
11440731	11440731	PRJNA867519_P_NODE_18789_length_281_cov_1.447115_g18635_i0	PRJNA867519	18789	281	1.447115	4.06639315	Flavobacterium	237	Bacteria	Bacteria	370	6.3e-98	NTclustered	gi\|2679314462\|gb\|CP085725.1\|	1176532	g18635	i0	91.176	97.0284697508897	272	24	97	0	9	280	1534371	1534642	Flavobacterium hankyongi strain KTce-4 chromosome, complete genome	blastn	27265	372	0.99462365591397806	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium hankyongi
12327266	12327266	PRJNA867519_P_NODE_28270_length_248_cov_0.880000_g28116_i0	PRJNA867519	28270	248	0.88	2.1824	Sphingobacterium mizutaii	1010	Bacteria	Bacteria	285	2.0299999999999997e-72	NTclustered	gi\|1231743971\|emb\|LT906468.1\|	1010	g28116	i0	88.841	1.58467741935484	233	24	100	2	17	248	1274200	1273969	Sphingobacterium mizutaii strain NCTC12149 genome assembly, chromosome: 1	blastn	393	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium mizutaii
12327296	12327296	PRJNA867519_P_NODE_33090_length_242_cov_0.911243_g32936_i0	PRJNA867519	33090	242	0.911243	2.20520806	Flavobacterium davisii	2906077	Bacteria	Bacteria	263	9.250000000000001e-66	NTclustered	gi\|2808924402\|gb\|CP097869.1\|	2906077	g32936	i0	86.307	92.4628099173554	241	33	99	0	2	242	3131795	3132035	Flavobacterium davisii strain GX-01 chromosome, complete genome	blastn	22376	263	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium davisii
12716552	12716552	PRJNA867519_P_NODE_21310_length_270_cov_1.279188_g21156_i0	PRJNA867519	21310	270	1.279188	3.4538076	Sphingobacterium	28453	Bacteria	Bacteria	499	7.349999999999998e-137	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g21156	i0	100	5	270	0	100	0	1	270	1879498	1879767	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	1350	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
13601878	13601878	PRJNA867519_P_NODE_4191_length_517_cov_1.040541_g4039_i0	PRJNA867519	4191	517	1.040541	5.37959697	Cloacibacterium caeni	2004710	Bacteria	Bacteria	69.4	5.03e-7	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g4039	i0	85.075	0.342359767891683	67	10	13	0	271	337	514173	514107	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	177	69.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
13990890	13990890	PRJNA867519_P_NODE_8491_length_382_cov_1.744337_g8337_i0	PRJNA867519	8491	382	1.744337	6.66336734	Emticicia	312278	Bacteria	Bacteria	638	2.2e-178	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g8337	i0	96.867	372.620418848168	383	9	100	3	1	382	441	821	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	142341	638	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
16150718	16150718	PRJNA867519_P_NODE_18493_length_282_cov_1.588517_g18339_i0	PRJNA867519	18493	282	1.588517	4.47961794	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	58.4	5.59e-4	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g18339	i0	100	2.31914893617021	31	0	11	0	157	187	526002	526032	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	654	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
16539579	16539579	PRJNA867519_P_NODE_9053_length_373_cov_1.890000_g8899_i0	PRJNA867519	9053	373	1.89	7.0497	root	1	Root_unresolved	Root_unresolved	52.8	0.035	NTclustered	gi\|2290501943\|gb\|CP103081.1\|	47678	g8899	i0	100	0.82573726541555	28	0	8	0	94	121	1978327	1978300	Bacteroides caccae strain BFG-101 chromosome, complete genome	blastn	308	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides caccae
17426371	17426371	PRJNA867519_P_NODE_32114_length_243_cov_0.905882_g31960_i0	PRJNA867519	32114	243	0.905882	2.20129326	Pontibacter russatus	2694929	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1802158094\|gb\|CP047984.1\|	2694929	g31960	i0	100	0.11522633744856	28	0	12	0	181	208	481630	481657	Pontibacter russatus strain BT326 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter russatus
18699375	18699375	PRJNA867519_P_NODE_135_length_1922_cov_3.562466_g90_i0	PRJNA867519	135	1922	3.562466	68.47059652	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	1520	0	NTclustered	gi\|2556922676\|gb\|CP129488.1\|	2202734	g90	i0	81.228	320.085848074922	1955	306	99	49	1	1920	3060578	3058650	MAG: Saprospiraceae bacterium isolate cMAG.8 chromosome, complete genome	blastn	615205	1520	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
18699519	18699519	PRJNA867519_P_NODE_32875_length_242_cov_0.911243_g32721_i0	PRJNA867519	32875	242	0.911243	2.20520806	Chryseotalea sp. WA131a	2824557	Bacteria	Bacteria	135	2.1e-27	NTclustered	gi\|2307074312\|gb\|CP073016.1\|	2824557	g32721	i0	80.571	1.28512396694215	175	34	72	0	1	175	2457611	2457437	MAG: Chryseotalea sp. WA131a chromosome, complete genome	blastn	311	135	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Chryseotaleaceae	Chryseotalea	Chryseotalea sp. WA131a
19974649	19974649	PRJNA867519_P_NODE_20016_length_275_cov_5.891089_g19862_i0	PRJNA867519	20016	275	5.891089	16.20049475	Aureispira anguillae	2864201	Bacteria	Bacteria	387	6.1e-103	NTclustered	gi\|2314744358\|dbj\|AP026867.1\|	2864201	g19862	i0	92.593	225.843636363636	270	18	98	2	2	270	219150	218882	Aureispira anguillae EL160426 DNA, complete genome	blastn	62107	387	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Aureispira	Aureispira anguillae
19974734	19974734	PRJNA867519_P_NODE_32836_length_242_cov_0.911243_g32682_i0	PRJNA867519	32836	242	0.911243	2.20520806	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	100	7.68e-17	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g32682	i0	76.233	2.97107438016529	223	33	88	12	30	242	3558310	3558098	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	719	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
20363345	20363345	PRJNA867519_P_NODE_25276_length_251_cov_1.505618_g25122_i0	PRJNA867519	25276	251	1.505618	3.77910118	Flavobacterium	237	Bacteria	Bacteria	291	4.43e-74	NTclustered	gi\|1003115209\|gb\|CP010992.1\|	996	g25122	i0	87.854	38.6294820717131	247	30	98	0	5	251	2465281	2465035	Flavobacterium columnare strain B185, complete genome	blastn	9696	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium columnare
21250199	21250199	PRJNA867519_P_NODE_14117_length_312_cov_1.531381_g13963_i0	PRJNA867519	14117	312	1.531381	4.77790872	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	520	6.649999999999998e-143	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g13963	i0	96.805	380.525641025641	313	6	100	2	1	312	113421	113730	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	118724	520	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
23800322	23800322	PRJNA867519_P_NODE_24199_length_256_cov_2.426230_g24045_i0	PRJNA867519	24199	256	2.42623	6.2111488	Psychroserpens ponticola	2932268	Bacteria	Bacteria	126	1.35e-24	NTclustered	gi\|2441525218\|gb\|CP116221.1\|	2932268	g24045	i0	81.818	3.703125	154	25	60	3	102	255	815113	815263	Psychroserpens ponticola strain MSW6 chromosome, complete genome	blastn	948	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Psychroserpens	Psychroserpens ponticola
25074164	25074164	PRJNA867519_P_NODE_18580_length_282_cov_1.334928_g18426_i0	PRJNA867519	18580	282	1.334928	3.76449696	Emticicia oligotrophica	312279	Bacteria	Bacteria	200	8.78e-47	NTclustered	gi\|387853393\|gb\|CP002961.1\|	929562	g18426	i0	88.485	0.585106382978723	165	19	59	0	15	179	1758103	1757939	Emticicia oligotrophica DSM 17448, complete genome	blastn	165	200	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
25074171	25074171	PRJNA867519_P_NODE_19200_length_279_cov_1.495146_g19046_i0	PRJNA867519	19200	279	1.495146	4.17145734	Ornithobacterium rhinotracheale	28251	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2895388669\|gb\|CP178594.1\|	28251	g19046	i0	100	0.100358422939068	28	0	10	0	5	32	1239658	1239631	Ornithobacterium rhinotracheale strain BR2936 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Ornithobacterium	Ornithobacterium rhinotracheale
25074195	25074195	PRJNA867519_P_NODE_22900_length_263_cov_0.926316_g22746_i0	PRJNA867519	22900	263	0.926316	2.43621108	Flavobacterium sp. Sr18	935222	Bacteria	Bacteria	403	5.75e-108	NTclustered	gi\|1818223938\|gb\|CP049329.1\|	935222	g22746	i0	94.318	553.102661596958	264	14	100	1	1	263	70541	70278	Flavobacterium sp. Sr18 chromosome, complete genome	blastn	145466	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. Sr18
25074206	25074206	PRJNA867519_P_NODE_25000_length_252_cov_2.005587_g24846_i0	PRJNA867519	25000	252	2.005587	5.05407924	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	150	7.879999999999999e-32	NTclustered	gi\|2874253891\|emb\|OY970066.1\|	866510	g24846	i0	88.618	3.38095238095238	123	14	49	0	130	252	235623	235745	MAG: uncultured Chitinophagaceae bacterium isolate MFD02581.bin.c.1 genome assembly, chromosome: 1	blastn	852	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
25074300	25074300	PRJNA867519_P_NODE_6920_length_417_cov_1.066860_g6766_i0	PRJNA867519	6920	417	1.06686	4.4488062	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	505	2.56e-138	NTclustered	gi\|309323798\|gb\|HM535520.1\|	152509	g6766	i0	98.936	74.9520383693046	282	3	68	0	136	417	1	282	Uncultured Bacteroidetes bacterium clone CM01189X1B01 16S ribosomal RNA gene, partial sequence	blastn	31255	505	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
25463636	25463636	PRJNA867519_P_NODE_11280_length_342_cov_3.319703_g11126_i0	PRJNA867519	11280	342	3.319703	11.35338426	Sphingobacterium	28453	Bacteria	Bacteria	580	3.329999999999999e-161	NTclustered	gi\|1231743971\|emb\|LT906468.1\|	1010	g11126	i0	97.118	442.581871345029	347	5	100	2	1	342	1278489	1278835	Sphingobacterium mizutaii strain NCTC12149 genome assembly, chromosome: 1	blastn	151363	580	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium mizutaii

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