metadata: contig_metadata: 26 rows where bioproject = "PRJNA927284" and tax

26 rows where bioproject = "PRJNA927284" 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
901874	901874	PRJNA927284_P_NODE_4301_length_292_cov_7.414449_g4094_i0	PRJNA927284	4301	292	7.414449	21.65019108	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	425	1.38e-114	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g4094	i0	92.881	313.585616438356	295	18	100	2	1	292	360925	360631	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	91567	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
2177204	2177204	PRJNA927284_P_NODE_3102_length_373_cov_4.203488_g2898_i0	PRJNA927284	3102	373	4.203488	15.67901024	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	588	2.1899999999999994e-163	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g2898	i0	95.161	299.11528150134	372	18	99	0	2	373	2978307	2978678	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	111570	588	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
2528250	2528250	PRJNA927284_P_NODE_1782_length_539_cov_10.498039_g1606_i0	PRJNA927284	1782	539	10.498039	56.58443021	Weeksellaceae	2762318	Bacteria	Bacteria	520	1.21e-142	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g1606	i0	90.819	342.734693877551	403	16	98	15	145	539	2158673	2158284	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	184734	525	0.990476190476191	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
6005014	6005014	PRJNA927284_P_NODE_1645_length_564_cov_2.912150_g1475_i0	PRJNA927284	1645	564	2.91215	16.424526	Panacibacter ginsenosidivorans	1813871	Bacteria	Bacteria	564	5.78e-156	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g1475	i0	84.991	214.785460992908	573	66	100	17	1	564	1672284	1672845	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	121139	564	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans
7279895	7279895	PRJNA927284_P_NODE_146_length_1891_cov_10.545650_g108_i1	PRJNA927284	146	1891	10.54565	199.4182415	Cloacibacterium caeni	2004710	Bacteria	Bacteria	1698	0	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g108	i1	87.634	376.271285034373	1496	141	78	36	1	1478	1872132	1873601	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	711529	1698	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
7279898	7279898	PRJNA927284_P_NODE_2026_length_496_cov_2.721627_g1838_i0	PRJNA927284	2026	496	2.721627	13.49926992	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	676	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g1838	i0	92.276	224.622983870968	479	33	96	4	1	477	2977684	2978160	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	111413	676	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
7279932	7279932	PRJNA927284_P_NODE_6526_length_205_cov_6.664773_g6319_i0	PRJNA927284	6526	205	6.664773	13.66278465	Flavobacterium sediminis	2201181	Bacteria	Bacteria	372	1.21e-98	NTclustered	gi\|1391188358\|gb\|CP029463.1\|	2201181	g6319	i0	99.51	686.287804878049	204	1	99	0	1	204	454254	454457	Flavobacterium sediminis strain MEBiC07310 chromosome, complete genome	blastn	140689	372	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sediminis
7630684	7630684	PRJNA927284_P_NODE_5686_length_231_cov_2.653465_g5479_i0	PRJNA927284	5686	231	2.653465	6.12950415	Aquirufa	2676247	Bacteria	Bacteria	185	1.9499999999999998e-42	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g5479	i0	81.435	326.108225108225	237	35	100	8	1	231	212924	213157	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	75331	185	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
9829645	9829645	PRJNA927284_P_NODE_6568_length_204_cov_3.582857_g6361_i0	PRJNA927284	6568	204	3.582857	7.30902828	Cloacibacterium caeni	2004710	Bacteria	Bacteria	353	4.36e-93	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g6361	i0	99.485	94.9950980392157	194	1	95	0	1	194	1875723	1875916	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	19379	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
10181240	10181240	PRJNA927284_P_NODE_9268_length_151_cov_14.655738_g9061_i0	PRJNA927284	9268	151	14.655738	22.13016438	Flavobacteriales	200644	Bacteria	Bacteria	230	5.299999999999999e-56	NTclustered	gi\|2831277486\|gb\|CP171010.1\|	1816680	g9061	i0	94.04	454.927152317881	151	9	100	0	1	151	494041	493891	Vaginella massiliensis strain WGS2087 chromosome, complete genome	blastn	68694	230	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Vaginella	Vaginella massiliensis
12381061	12381061	PRJNA927284_P_NODE_8410_length_167_cov_1.543478_g8203_i0	PRJNA927284	8410	167	1.543478	2.57760826	Flavobacterium sp. ZE23DGlu08	3059026	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2548163737\|gb\|CP130045.1\|	3059026	g8203	i0	100	0.167664670658683	28	0	17	0	48	75	660295	660268	Flavobacterium sp. ZE23DGlu08 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. ZE23DGlu08
13655572	13655572	PRJNA927284_P_NODE_5711_length_230_cov_3.253731_g5504_i0	PRJNA927284	5711	230	3.253731	7.4835813	Mucilaginibacter sp. KACC 22063	3025666	Bacteria	Bacteria	398	2.2899999999999997e-106	NTclustered	gi\|2446117353\|gb\|CP117877.1\|	3025666	g5504	i0	97.826	236.813043478261	230	5	100	0	1	230	1044634	1044405	Mucilaginibacter sp. KACC 22063 chromosome, complete genome	blastn	54467	398	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. KACC 22063
15280545	15280545	PRJNA927284_P_NODE_5512_length_237_cov_9.634615_g5305_i0	PRJNA927284	5512	237	9.634615	22.83403755	Flavobacterium	237	Bacteria	Bacteria	405	1.42e-108	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g5305	i0	97.479	468.299578059072	238	5	100	1	1	237	980404	980167	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	110987	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
16555053	16555053	PRJNA927284_P_NODE_1453_length_614_cov_6.369231_g1297_i0	PRJNA927284	1453	614	6.369231	39.10707834	Flavobacterium	237	Bacteria	Bacteria	918	0	NTclustered	gi\|2179223253\|gb\|OM281347.1\|	239	g1297	i0	93.669	102.019543973941	616	35	100	4	1	614	755	142	Flavobacterium sp. strain DSTF-M1 (type strain) 16S ribosomal RNA gene, partial sequence	blastn	62640	918	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
16555062	16555062	PRJNA927284_P_NODE_7253_length_188_cov_3.823899_g7046_i0	PRJNA927284	7253	188	3.823899	7.18893012	Flavobacterium	237	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|2450142035\|gb\|OQ546399.1\|	239	g7046	i0	100	109.005319148936	188	0	100	0	1	188	675	488	Flavobacterium sp. strain CA_59 16S ribosomal RNA gene, partial sequence	blastn	20493	348	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
17830062	17830062	PRJNA927284_P_NODE_6494_length_206_cov_4.672316_g6287_i0	PRJNA927284	6494	206	4.672316	9.62497096	Mucilaginibacter	423349	Bacteria	Bacteria	285	1.6299999999999998e-72	NTclustered	gi\|1953477154\|gb\|CP066775.1\|	2682091	g6287	i0	92.893	318.684466019417	197	12	95	2	11	206	2178144	2178339	Mucilaginibacter ginkgonis strain HMF7856 chromosome, complete genome	blastn	65649	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter ginkgonis
18753439	18753439	PRJNA927284_P_NODE_5975_length_222_cov_3.056995_g5768_i0	PRJNA927284	5975	222	3.056995	6.7865289	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	411	2.8199999999999996e-110	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g5768	i0	100	279.914414414414	222	0	100	0	1	222	3293507	3293728	Lacibacter sp. MH-610 chromosome	blastn	62141	411	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
20028461	20028461	PRJNA927284_P_NODE_2136_length_481_cov_3.716814_g1946_i0	PRJNA927284	2136	481	3.716814	17.87787534	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	833	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g1946	i0	97.921	272.559251559252	481	10	100	0	1	481	2978678	2978198	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	131101	833	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
20028466	20028466	PRJNA927284_P_NODE_2616_length_418_cov_3.275064_g2417_i0	PRJNA927284	2616	418	3.275064	13.68976752	Flavobacterium channae	2897181	Bacteria	Bacteria	555	2.51e-153	NTclustered	gi\|2164478757\|gb\|CP089096.1\|	2897181	g2417	i0	99.029	628.248803827751	309	3	97	0	110	418	485947	486255	Flavobacterium channae strain KSM-R2A30 chromosome, complete genome	blastn	262608	555	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium channae
20028468	20028468	PRJNA927284_P_NODE_276_length_1513_cov_21.905660_g221_i0	PRJNA927284	276	1513	21.90566	331.4326358	Chryseobacterium sp. LJ668	2864040	Bacteria	Bacteria	56.5	0.012	NTclustered	gi\|2081116358\|gb\|CP080443.1\|	2864040	g221	i0	100	0.0198281559814937	30	0	2	0	98	127	3225904	3225933	Chryseobacterium sp. LJ668 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. LJ668
21303860	21303860	PRJNA927284_P_NODE_2977_length_383_cov_3.644068_g2775_i0	PRJNA927284	2977	383	3.644068	13.95678044	Panacibacter ginsenosidivorans	1813871	Bacteria	Bacteria	412	1.4499999999999998e-110	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g2775	i0	87.158	220.731070496084	366	43	95	4	20	383	1673419	1673782	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	84540	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans
22578972	22578972	PRJNA927284_P_NODE_138_length_1934_cov_12.333333_g108_i0	PRJNA927284	138	1934	12.333333	238.52666022	Saprospira sp. CCB-QB6	3023936	Bacteria	Bacteria	1177	0	NTclustered	gi\|2440421932\|gb\|CP116808.1\|	3023936	g108	i0	81.575	306.09462254395	1498	211	76	54	414	1882	1611180	1609719	Saprospira sp. CCB-QB6 chromosome, complete genome	blastn	591987	1177	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Saprospira	Saprospira sp. CCB-QB6
23854132	23854132	PRJNA927284_P_NODE_299_length_1454_cov_23.268070_g221_i1	PRJNA927284	299	1454	23.26807	338.3177378	Chryseobacterium sp. LJ668	2864040	Bacteria	Bacteria	56.5	0.012	NTclustered	gi\|2081116358\|gb\|CP080443.1\|	2864040	g221	i1	100	0.0206327372764787	30	0	2	0	1328	1357	3225933	3225904	Chryseobacterium sp. LJ668 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. LJ668
23854143	23854143	PRJNA927284_P_NODE_4759_length_269_cov_4.866667_g4552_i0	PRJNA927284	4759	269	4.866667	13.09133423	Flavobacterium cyclinae	2895947	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g4552	i0	100	666.921933085502	269	0	100	0	1	269	982171	981903	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	179402	497	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
27056451	27056451	PRJNA927284_P_NODE_7622_length_181_cov_1.967105_g7415_i0	PRJNA927284	7622	181	1.967105	3.56046005	Segatella copri	165179	Bacteria	Bacteria	40	0.028	NR	RGS16953.1	165179	g7415	i0	51	0.812154696132597	49	22	79.6	2	38	181	25	72	RGS16953.1 hypothetical protein DWY11_05730, partial [Segatella copri]	diamond	147	40	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
28105723	28105723	PRJNA927284_P_NODE_7305_length_187_cov_2.430380_g7098_i0	PRJNA927284	7305	187	2.43038	4.5448106	Pseudomonadati	3379134	Bacteria	Bacteria	62	2.88e-9	NR	MBK9459220.1	2044944	g7098	i0	46.4	2.53475935828877	56	30	89.8	0	2	169	749	804	MBK9459220.1 cadherin-like domain-containing protein [Sphingobacteriales bacterium]	diamond	474	62	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales 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);;