metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA1218816" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA1218816" and tax_phylum = "Bacteroidota"

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
1608111	1608111	PRJNA1218816_P_NODE_44902_length_284_cov_0.919431_g44469_i0	PRJNA1218816	44902	284	0.919431	2.61118404	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	357	4.96e-94	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g44469	i0	89.437	417.855633802817	284	28	100	2	1	284	956181	955900	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	118671	357	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
2321552	2321552	PRJNA1218816_P_NODE_14262_length_627_cov_6.079422_g13839_i0	PRJNA1218816	14262	627	6.079422	38.11797594	Porphyromonas	836	Bacteria	Bacteria	1153	0	NTclustered	gi\|1274923455\|gb\|CP024600.1\|	837	g13839	i0	99.841	182.006379585327	627	1	100	0	1	627	222678	222052	Porphyromonas gingivalis strain KCOM 2801 chromosome, complete genome	blastn	114118	1158	0.995682210708117	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
2321638	2321638	PRJNA1218816_P_NODE_63242_length_239_cov_2.662651_g62809_i0	PRJNA1218816	63242	239	2.662651	6.36373589	Bacteroidota	976	Bacteria	Bacteria	307	4.15e-79	NTclustered	gi\|2814788381\|emb\|OY781965.2\|	2030927	g62809	i0	91.189	202.790794979079	227	19	95	1	14	239	1389766	1389540	MAG: Bacteroidales bacterium isolate 351424ce-103a-4fdb-9a77-f202f7f12de1 genome assembly, chromosome: 1	blastn	48467	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
2884204	2884204	PRJNA1218816_P_NODE_32203_length_351_cov_1.895683_g31770_i0	PRJNA1218816	32203	351	1.895683	6.65384733	Reichenbachiella agarivorans	2979464	Bacteria	Bacteria	311	4.96e-80	NTclustered	gi\|2311319784\|gb\|CP106679.1\|	2979464	g31770	i0	84.036	173.176638176638	332	44	94	9	14	340	410479	410806	Reichenbachiella agarivorans strain BKB1-1 chromosome, complete genome	blastn	60785	311	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Reichenbachiellaceae	Reichenbachiella	Reichenbachiella agarivorans
3596755	3596755	PRJNA1218816_P_NODE_24503_length_425_cov_1.221591_g24070_i0	PRJNA1218816	24503	425	1.221591	5.19176175	Bacteroidota	976	Bacteria	Bacteria	568	3.289999999999999e-157	NTclustered	gi\|1644139391\|gb\|CP040106.1\|	1807691	g24070	i0	90.824	322.602352941176	425	37	100	2	1	425	63274	63696	Echinicola rosea strain JL3085 chromosome, complete genome	blastn	137106	569	0.998242530755712	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Echinicola	Echinicola rosea
4160338	4160338	PRJNA1218816_P_NODE_35844_length_328_cov_0.874510_g35411_i0	PRJNA1218816	35844	328	0.87451	2.8683928	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	451	2.6e-122	NTclustered	gi\|2874253850\|emb\|OY969906.1\|	866510	g35411	i0	91.463	210.198170731707	328	28	100	0	1	328	3014260	3013933	MAG: uncultured Chitinophagaceae bacterium isolate MFD05502.bin.c.1 genome assembly, chromosome: 1	blastn	68945	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
4160497	4160497	PRJNA1218816_P_NODE_52704_length_254_cov_1.701657_g52271_i0	PRJNA1218816	52704	254	1.701657	4.32220878	Hymenobacter monticola	1705399	Bacteria	Bacteria	431	2.539999999999999e-116	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g52271	i0	97.255	289.838582677165	255	5	100	2	1	254	1095597	1095850	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	73619	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
5436432	5436432	PRJNA1218816_P_NODE_13105_length_668_cov_2.221849_g12687_i0	PRJNA1218816	13105	668	2.221849	14.84195132	Proteiniphilum propionicum	2829812	Bacteria	Bacteria	966	0	NTclustered	gi\|2194522320\|gb\|CP073586.1\|	2829812	g12687	i0	92.814	476.652694610778	668	47	100	1	1	668	2828883	2828217	Proteiniphilum propionicum strain JNU-WLY501 chromosome, complete genome	blastn	318404	966	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Proteiniphilum	Proteiniphilum propionicum
5436728	5436728	PRJNA1218816_P_NODE_54585_length_250_cov_0.870056_g54152_i0	PRJNA1218816	54585	250	0.870056	2.17514	Cytophagaceae bacterium	2026729	Bacteria	Bacteria	163	1e-35	NTclustered	gi\|1702192050\|gb\|CP030886.1\|	2026729	g54152	i0	79.032	287.788	248	45	98	7	1	246	1139236	1138994	Cytophagaceae bacterium isolate ECT2AJA-110-C chromosome	blastn	71947	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		Cytophagaceae bacterium
6711051	6711051	PRJNA1218816_P_NODE_24166_length_429_cov_1.637640_g23733_i0	PRJNA1218816	24166	429	1.63764	7.0254756	Niabella sp. I6	2849502	Bacteria	Bacteria	649	0	NTclustered	gi\|2070850032\|gb\|CP079214.1\|	2849502	g23733	i0	93.981	274.027972027972	432	20	100	6	1	429	3744656	3745084	Niabella sp. I6 chromosome	blastn	117558	649	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella sp. I6
7986940	7986940	PRJNA1218816_P_NODE_59387_length_245_cov_0.895349_g58954_i0	PRJNA1218816	59387	245	0.895349	2.19360505	Chryseobacterium sp. HR92	3094839	Bacteria	Bacteria	398	2.47e-106	NTclustered	gi\|2625487128\|gb\|CP139139.1\|	3094839	g58954	i0	95.918	10.0122448979592	245	10	100	0	1	245	3855273	3855029	Chryseobacterium sp. HR92 chromosome, complete genome	blastn	2453	398	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. HR92
9974320	9974320	PRJNA1218816_P_NODE_17588_length_541_cov_1.358974_g17159_i0	PRJNA1218816	17588	541	1.358974	7.35204934	Sphingobacterium	28453	Bacteria	Bacteria	503	1.22e-137	NTclustered	gi\|1601834842\|gb\|CP038029.1\|	561061	g17159	i0	83.636	436.059149722736	550	75	100	14	1	541	27502	28045	Sphingobacterium psychroaquaticum strain SJ-25 chromosome, complete genome	blastn	235908	503	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium psychroaquaticum
10537372	10537372	PRJNA1218816_P_NODE_55469_length_249_cov_0.875000_g55036_i0	PRJNA1218816	55469	249	0.875	2.17875	Prevotella dentalis	52227	Bacteria	Bacteria	261	3.44e-65	NTclustered	gi\|433301591\|gb\|CP003368.1\|	908937	g55036	i0	86.25	22.5261044176707	240	33	96	0	2	241	543303	543542	Prevotella dentalis DSM 3688 chromosome 1, complete sequence	blastn	5609	261	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella dentalis
10537471	10537471	PRJNA1218816_P_NODE_7229_length_1022_cov_1.851423_g6908_i0	PRJNA1218816	7229	1022	1.851423	18.92154306	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	1642	0	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g6908	i0	95.627	353.85518590998	1029	36	99	7	3	1022	786716	787744	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	361640	1642	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
11249597	11249597	PRJNA1218816_P_NODE_37649_length_317_cov_1.893443_g37216_i0	PRJNA1218816	37649	317	1.893443	6.00221431	Ferruginibacter	1004303	Bacteria	Bacteria	542	1.45e-149	NTclustered	gi\|2129682579\|gb\|CP086063.1\|	563172	g37216	i0	97.476	263.82334384858	317	8	100	0	1	317	1664969	1664653	Ferruginibacter lapsinanis strain KACC 15035 chromosome, complete genome	blastn	83632	542	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter lapsinanis
11249622	11249622	PRJNA1218816_P_NODE_51989_length_257_cov_1.250000_g51556_i0	PRJNA1218816	51989	257	1.25	3.2125	Capnocytophaga	1016	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|2797268018\|gb\|CP162011.1\|	327575	g51556	i0	100	302.525291828794	257	0	100	0	1	257	420815	421071	Capnocytophaga leadbetteri strain F0087 isolate D204 chromosome, complete genome	blastn	77749	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
13087208	13087208	PRJNA1218816_P_NODE_53491_length_251_cov_2.264045_g53058_i0	PRJNA1218816	53491	251	2.264045	5.68275295	Prevotella dentalis	52227	Bacteria	Bacteria	307	4.4e-79	NTclustered	gi\|433303004\|gb\|CP003369.1\|	908937	g53058	i0	88.933	42.5258964143426	253	22	100	6	1	251	366448	366200	Prevotella dentalis DSM 3688 chromosome 2, complete sequence	blastn	10674	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella dentalis
13087317	13087317	PRJNA1218816_P_NODE_64091_length_227_cov_2.500000_g63658_i0	PRJNA1218816	64091	227	2.5	5.675	Bergeyella cardium	1585976	Bacteria	Bacteria	350	6.400000000000001e-92	NTclustered	gi\|2504455906\|gb\|CP121693.1\|	1585976	g63658	i0	98.485	411.863436123348	198	3	87	0	13	210	993493	993296	Bergeyella cardium strain BC chromosome, complete genome	blastn	93493	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella cardium
13799618	13799618	PRJNA1218816_P_NODE_34711_length_334_cov_1.766284_g34278_i0	PRJNA1218816	34711	334	1.766284	5.89938856	Hymenobacter	89966	Bacteria	Bacteria	394	4.539999999999999e-105	NTclustered	gi\|972940812\|gb\|CP013909.1\|	1411621	g34278	i0	87.906	60.3203592814371	339	36	100	2	1	334	2787869	2787531	Hymenobacter sedentarius strain DG5B chromosome, complete genome	blastn	20147	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sedentarius
15073883	15073883	PRJNA1218816_P_NODE_62852_length_241_cov_0.916667_g62419_i0	PRJNA1218816	62852	241	0.916667	2.20916747	Porphyromonas	836	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1274919567\|gb\|CP024601.1\|	837	g62419	i0	100	35	241	0	100	0	1	241	1655300	1655060	Porphyromonas gingivalis strain KCOM 2799 chromosome, complete genome	blastn	8435	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
15636186	15636186	PRJNA1218816_P_NODE_24173_length_429_cov_1.514045_g23740_i0	PRJNA1218816	24173	429	1.514045	6.49525305	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	592	1.9699999999999998e-164	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g23740	i0	91.475	430.825174825175	434	32	100	5	1	429	2012786	2013219	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	184824	592	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
16348759	16348759	PRJNA1218816_P_NODE_43733_length_288_cov_3.316279_g43300_i0	PRJNA1218816	43733	288	3.316279	9.55088352	Porphyromonas	836	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|1274919567\|gb\|CP024601.1\|	837	g43300	i0	100	439.819444444444	288	0	100	0	1	288	1548406	1548119	Porphyromonas gingivalis strain KCOM 2799 chromosome, complete genome	blastn	126668	532	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
16348772	16348772	PRJNA1218816_P_NODE_49733_length_264_cov_6.759162_g49300_i0	PRJNA1218816	49733	264	6.759162	17.84418768	Weeksellaceae	2762318	Bacteria	Bacteria	433	7.37e-117	NTclustered	gi\|1566847344\|gb\|CP035532.1\|	253	g49300	i0	96.212	468.541666666667	264	10	100	0	1	264	2610747	2611010	Chryseobacterium indologenes strain StR 01 chromosome, complete genome	blastn	123695	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
16910387	16910387	PRJNA1218816_P_NODE_25754_length_410_cov_1.252226_g25321_i0	PRJNA1218816	25754	410	1.252226	5.1341266	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	473	7.09e-129	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g25321	i0	87.47	441.865853658537	415	46	100	6	1	410	443506	443919	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	181165	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
19459443	19459443	PRJNA1218816_P_NODE_47976_length_271_cov_1.555556_g47543_i0	PRJNA1218816	47976	271	1.555556	4.21555676	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	315	2.87e-81	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g47543	i0	87.778	156.180811808118	270	31	99	2	4	271	2978924	2979193	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	42325	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
19459491	19459491	PRJNA1218816_P_NODE_52676_length_254_cov_1.889503_g52243_i0	PRJNA1218816	52676	254	1.889503	4.79933762	Fluviicola sp.	1917219	Bacteria	Bacteria	315	2.66e-81	NTclustered	gi\|2916411764\|gb\|CP170456.1\|	1917219	g52243	i0	89.062	610.023622047244	256	24	100	4	1	254	1783448	1783195	MAG: Fluviicola sp. isolate tig00002473 chromosome, complete genome	blastn	154946	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola sp.
20734947	20734947	PRJNA1218816_P_NODE_54037_length_251_cov_0.865169_g53604_i0	PRJNA1218816	54037	251	0.865169	2.17157419	Ferruginibacter albus	2875540	Bacteria	Bacteria	348	2.5900000000000005e-91	NTclustered	gi\|2096325587\|gb\|CP083388.1\|	2875540	g53604	i0	94.643	206.035856573705	224	12	89	0	21	244	769020	769243	Ferruginibacter albus strain KIS38-8 chromosome, complete genome	blastn	51715	348	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter albus
20734982	20734982	PRJNA1218816_P_NODE_57637_length_247_cov_0.885057_g57204_i0	PRJNA1218816	57637	247	0.885057	2.18609079	Chryseobacterium gambrini	373672	Bacteria	Bacteria	167	7.64e-37	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g57204	i0	80.365	17.3157894736842	219	43	89	0	1	219	1997235	1997453	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	4277	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
22723177	22723177	PRJNA1218816_P_NODE_44758_length_284_cov_1.867299_g44325_i0	PRJNA1218816	44758	284	1.867299	5.30312916	Sphingobacteriaceae	84566	Bacteria	Bacteria	359	1.38e-94	NTclustered	gi\|1721641612\|gb\|CP042436.1\|	398053	g44325	i0	93.724	274.647887323944	239	15	84	0	41	279	2016845	2017083	Mucilaginibacter ginsenosidivorans strain Gsoil 3017 chromosome, complete genome	blastn	78000	361	0.994459833795014	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter ginsenosidivorans
23998330	23998330	PRJNA1218816_P_NODE_14599_length_618_cov_2.009174_g14175_i0	PRJNA1218816	14599	618	2.009174	12.41669532	Saprospiraceae	89374	Bacteria	Bacteria	540	1.0699999999999999e-148	NTclustered	gi\|2422108806\|gb\|CP110854.1\|	1008	g14175	i0	82.742	370.907766990291	620	94	99	10	1	615	1646977	1647588	Saprospira grandis strain WH chromosome, complete genome	blastn	229221	540	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Saprospira	Saprospira grandis
23998333	23998333	PRJNA1218816_P_NODE_21019_length_475_cov_1.211443_g20586_i0	PRJNA1218816	21019	475	1.211443	5.75435425	Haliscomenobacter	2349	Bacteria	Bacteria	363	1.88e-95	NTclustered	gi\|470488547\|ref\|NR_076877.1\|	2350	g20586	i0	90.545	261.054736842105	275	24	58	2	201	475	1483	1755	Haliscomenobacter hydrossis strain DSM 1100 23S ribosomal RNA gene, complete sequence	blastn	124001	363	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
24559693	24559693	PRJNA1218816_P_NODE_58280_length_246_cov_0.890173_g57847_i0	PRJNA1218816	58280	246	0.890173	2.18982558	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g57847	i0	98.78	99.8455284552846	246	3	100	0	1	246	340761	340516	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	24562	438	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei

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