metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJEB7366" and tax

23 rows where analysis = "blastn", bioproject = "PRJEB7366" 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
135275	135275	PRJEB7366_P_NODE_3161_length_534_cov_2.903808_g2754_i0	PRJEB7366	3161	534	2.903808	15.50633472	Ferruginibacter lapsinanis	563172	Bacteria	Bacteria	776	0	NTclustered	gi\|2129682579\|gb\|CP086063.1\|	563172	g2754	i0	93.346	281.383895131086	526	33	98	2	10	534	1662644	1662120	Ferruginibacter lapsinanis strain KACC 15035 chromosome, complete genome	blastn	150259	776	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter lapsinanis
995529	995529	PRJEB7366_P_NODE_12841_length_223_cov_4.186170_g12407_i0	PRJEB7366	12841	223	4.18617	9.3351591	Bacteroidota	976	Bacteria	Bacteria	396	7.939999999999995e-106	NTclustered	gi\|2625929225\|gb\|OR899283.1\|	239	g12407	i0	98.661	105.358744394619	224	2	100	1	1	223	465	688	Flavobacterium sp. strain LS1 16S ribosomal RNA gene, partial sequence	blastn	23495	396	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
2270649	2270649	PRJEB7366_P_NODE_23222_length_156_cov_1.280992_g22788_i0	PRJEB7366	23222	156	1.280992	1.99834752	Petrimonas	307628	Bacteria	Bacteria	217	4.309999999999999e-52	NTclustered	gi\|2722769460\|gb\|CP073276.1\|	285070	g22788	i0	96.212	252.589743589744	132	5	85	0	1	132	206474	206605	Petrimonas sulfuriphila strain LBM11003 chromosome, complete genome	blastn	39404	217	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Petrimonas	Petrimonas sulfuriphila
2270657	2270657	PRJEB7366_P_NODE_622_length_1193_cov_5.721071_g132_i2	PRJEB7366	622	1193	5.721071	68.25237703	Phnomibacter	2836216	Bacteria	Bacteria	1906	0	NTclustered	gi\|1783227364\|gb\|CP046566.1\|	2676868	g132	i2	95.485	259.98742665549	1196	50	100	4	1	1193	922756	923950	Phnomibacter ginsenosidimutans strain SB-02 chromosome, complete genome	blastn	310165	1906	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Phnomibacter	Phnomibacter ginsenosidimutans
2685349	2685349	PRJEB7366_P_NODE_443_length_1374_cov_5.245706_g132_i1	PRJEB7366	443	1374	5.245706	72.07600044	Ferruginibacter lapsinanis	563172	Bacteria	Bacteria	1788	0	NTclustered	gi\|2129682579\|gb\|CP086063.1\|	563172	g132	i1	90.203	249.064774381368	1378	125	100	10	1	1374	1664048	1662677	Ferruginibacter lapsinanis strain KACC 15035 chromosome, complete genome	blastn	342215	1788	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter lapsinanis
4823592	4823592	PRJEB7366_P_NODE_21904_length_161_cov_1.642857_g21470_i0	PRJEB7366	21904	161	1.642857	2.64499977	Runella	105	Bacteria	Bacteria	215	1.61e-51	NTclustered	gi\|470488975\|ref\|NR_076898.1\|	106	g21470	i0	91.195	129.366459627329	159	12	98	2	1	158	345	502	Runella slithyformis strain DSM 19594 23S ribosomal RNA gene, complete sequence	blastn	20828	215	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella slithyformis
9062542	9062542	PRJEB7366_P_NODE_3468_length_508_cov_2.854123_g3051_i0	PRJEB7366	3468	508	2.854123	14.49894484	Ferruginibacter lapsinanis	563172	Bacteria	Bacteria	586	1.0999999999999996e-162	NTclustered	gi\|2129682579\|gb\|CP086063.1\|	563172	g3051	i0	87.976	411.783464566929	499	57	98	3	3	499	1662147	1662644	Ferruginibacter lapsinanis strain KACC 15035 chromosome, complete genome	blastn	209186	586	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter lapsinanis
11198844	11198844	PRJEB7366_P_NODE_2889_length_560_cov_198.224762_g2486_i0	PRJEB7366	2889	560	198.224762	1110.0586672	Chitinophagaceae	563835	Bacteria	Bacteria	990	0	NTclustered	gi\|298364428\|gb\|HM124372.1\|	796105	g2486	i0	98.571	101.891071428571	560	8	100	0	1	560	180	739	Terrimonas sp. 16-45A 16S ribosomal RNA gene, partial sequence	blastn	57059	990	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Terrimonas	Terrimonas sp. 16-45A
12474484	12474484	PRJEB7366_P_NODE_18350_length_179_cov_1.111111_g17916_i0	PRJEB7366	18350	179	1.111111	1.98888869	Paraflavitalea	2698688	Bacteria	Bacteria	230	6.529999999999999e-56	NTclustered	gi\|1475989234\|gb\|CP032157.1\|	2315862	g17916	i0	94.04	105.983240223464	151	9	84	0	12	162	4952609	4952459	Paraflavitalea soli strain 5GH32-13 chromosome, complete genome	blastn	18971	230	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Paraflavitalea	Paraflavitalea soli
12888804	12888804	PRJEB7366_P_NODE_18751_length_176_cov_2.907801_g18317_i0	PRJEB7366	18751	176	2.907801	5.11772976	Flavobacterium marginilacus	3003256	Bacteria	Bacteria	309	7.98e-80	NTclustered	gi\|2476885802\|gb\|CP113975.3\|	3003256	g18317	i0	98.295	557.181818181818	176	3	100	0	1	176	441814	441639	Flavobacterium marginilacus strain IMCC34673 chromosome, complete genome	blastn	98064	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium marginilacus
13748938	13748938	PRJEB7366_P_NODE_12911_length_223_cov_1.228723_g12477_i0	PRJEB7366	12911	223	1.228723	2.74005229	Chitinophaga	79328	Bacteria	Bacteria	233	6.59e-57	NTclustered	gi\|1804515774\|gb\|CP048113.1\|	2703787	g12477	i0	90.395	151.358744394619	177	17	79	0	1	177	5627009	5627185	Chitinophaga agri strain H33E-04 chromosome, complete genome	blastn	33753	233	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga agri
16711923	16711923	PRJEB7366_P_NODE_17854_length_182_cov_0.979592_g17420_i0	PRJEB7366	17854	182	0.979592	1.78285744	Hymenobacter baengnokdamensis	2615203	Bacteria	Bacteria	307	2.99e-79	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g17420	i0	97.238	609.923076923077	181	5	99	0	1	181	1424901	1424721	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	111006	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
16711926	16711926	PRJEB7366_P_NODE_19594_length_172_cov_1.744526_g19160_i0	PRJEB7366	19594	172	1.744526	3.00058472	Runella sp. SP2	2268026	Bacteria	Bacteria	241	2.87e-59	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g19160	i0	91.908	407.18023255814	173	13	100	1	1	172	5735330	5735158	Runella sp. SP2 chromosome, complete genome	blastn	70035	241	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
17986818	17986818	PRJEB7366_P_NODE_13935_length_212_cov_1.350282_g13501_i0	PRJEB7366	13935	212	1.350282	2.86259784	Pedobacter aquae	2605747	Bacteria	Bacteria	287	4.69e-73	NTclustered	gi\|1733060322\|gb\|CP043329.1\|	2605747	g13501	i0	91.038	373.849056603774	212	19	100	0	1	212	9019	8808	Pedobacter aquae strain CJ43 chromosome, complete genome	blastn	79256	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter aquae
17986822	17986822	PRJEB7366_P_NODE_14935_length_203_cov_1.428571_g14501_i0	PRJEB7366	14935	203	1.428571	2.89999913	Lacinutrix venerupis	1486034	Bacteria	Bacteria	141	3.67e-29	NTclustered	gi\|1134983573\|gb\|CP019352.1\|	1486034	g14501	i0	85.714	2	133	19	66	0	1	133	344149	344281	Lacinutrix venerupis strain DOK2-8, complete genome	blastn	406	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Lacinutrix	Lacinutrix venerupis
19260848	19260848	PRJEB7366_P_NODE_21636_length_162_cov_2.456693_g21202_i0	PRJEB7366	21636	162	2.456693	3.97984266	Runella sp. SP2	2268026	Bacteria	Bacteria	278	2.04e-70	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g21202	i0	97.531	376.141975308642	162	4	100	0	1	162	5734268	5734107	Runella sp. SP2 chromosome, complete genome	blastn	60935	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
20536169	20536169	PRJEB7366_P_NODE_24857_length_150_cov_1.121739_g24423_i0	PRJEB7366	24857	150	1.121739	1.6826085	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	174	2.5e-39	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g24423	i0	88.356	35.8133333333333	146	16	97	1	3	148	443917	443773	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	5372	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
21397678	21397678	PRJEB7366_P_NODE_2077_length_676_cov_1.892356_g1717_i0	PRJEB7366	2077	676	1.892356	12.79232656	Hymenobacter	89966	Bacteria	Bacteria	1038	0	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g1717	i0	94.395	296.190828402367	678	34	100	4	1	676	1423606	1424281	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	200225	1042	0.99616122840691	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
21397685	21397685	PRJEB7366_P_NODE_9817_length_265_cov_3.221739_g9383_i0	PRJEB7366	9817	265	3.221739	8.53760835	Phnomibacter	2836216	Bacteria	Bacteria	457	4.39e-124	NTclustered	gi\|1783227364\|gb\|CP046566.1\|	2676868	g9383	i0	97.744	228.754716981132	266	4	100	2	1	265	922732	922468	Phnomibacter ginsenosidimutans strain SB-02 chromosome, complete genome	blastn	60620	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Phnomibacter	Phnomibacter ginsenosidimutans
21812049	21812049	PRJEB7366_P_NODE_538_length_1283_cov_7.652244_g142_i1	PRJEB7366	538	1283	7.652244	98.17829052	Cloacibacterium caeni	2004710	Bacteria	Bacteria	2191	0	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g142	i1	97.508	421.613406079501	1284	28	100	4	1	1283	2731937	2733217	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	540930	2191	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
22672419	22672419	PRJEB7366_P_NODE_16698_length_189_cov_2.246753_g16264_i0	PRJEB7366	16698	189	2.246753	4.24636317	Hoylesella	2974257	Bacteria	Bacteria	327	2.41e-85	NTclustered	gi\|2127571982\|gb\|CP085926.1\|	28127	g16264	i0	97.884	223.179894179894	189	4	100	0	1	189	210393	210205	Hoylesella buccalis strain FDAARGOS_1588 chromosome, complete genome	blastn	42181	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella buccalis
25221681	25221681	PRJEB7366_P_NODE_22140_length_160_cov_1.888000_g21706_i0	PRJEB7366	22140	160	1.888	3.0208	Flavobacterium	237	Bacteria	Bacteria	291	2.5799999999999998e-74	NTclustered	gi\|470491666\|ref\|NR_077051.1\|	312277	g21706	i0	99.375	420	160	1	100	0	1	160	2805	2646	Flavobacterium indicum strain GPTSA100-9 23S ribosomal RNA gene, complete sequence	blastn	67200	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
25221695	25221695	PRJEB7366_P_NODE_8880_length_283_cov_3.088710_g8446_i0	PRJEB7366	8880	283	3.08871	8.7410493	Phnomibacter	2836216	Bacteria	Bacteria	466	7.87e-127	NTclustered	gi\|1783227364\|gb\|CP046566.1\|	2676868	g8446	i0	96.454	139.60777385159	282	10	99	0	1	282	1730500	1730781	Phnomibacter ginsenosidimutans strain SB-02 chromosome, complete genome	blastn	39509	466	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Phnomibacter	Phnomibacter ginsenosidimutans

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