metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA556842" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA556842" 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
521759	521759	PRJNA556842_P_NODE_1641_length_811_cov_5.447028_g1269_i0	PRJNA556842	1641	811	5.447028	44.17539708	Bacteroides faecium	2715212	Bacteria	Bacteria	874	0	NTclustered	gi\|1828977791\|gb\|CP050831.1\|	2715212	g1269	i0	86.414	515.057953144266	817	89	100	16	1	811	309323	308523	Bacteroides faecium strain CBA7301 chromosome, complete genome	blastn	417712	874	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides faecium
1124145	1124145	PRJNA556842_P_NODE_10161_length_239_cov_3.628713_g9656_i0	PRJNA556842	10161	239	3.628713	8.67262407	Segatella	2974251	Bacteria	Bacteria	398	2.4e-106	NTclustered	gi\|1540054687\|emb\|LR134384.1\|	28135	g9656	i0	96.653	255.569037656904	239	8	100	0	1	239	440809	440571	Prevotella oris strain NCTC13071 genome assembly, chromosome: 1	blastn	61081	398	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella oris
2399578	2399578	PRJNA556842_P_NODE_6422_length_344_cov_2.078176_g5919_i0	PRJNA556842	6422	344	2.078176	7.14892544	Cloacibacterium	501783	Bacteria	Bacteria	568	2.6099999999999992e-157	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g5919	i0	96.784	465.636627906977	342	7	99	4	1	342	129651	129314	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	160179	568	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
4952316	4952316	PRJNA556842_P_NODE_12524_length_200_cov_1.619632_g12019_i0	PRJNA556842	12524	200	1.619632	3.239264	Pedobacter	84567	Bacteria	Bacteria	326	9.27e-85	NTclustered	gi\|1904430191\|gb\|CP061171.1\|	2766984	g12019	i0	96	427.53	200	8	100	0	1	200	13659	13858	Pedobacter sp. SW-16 chromosome, complete genome	blastn	85506	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter riviphilus
4952326	4952326	PRJNA556842_P_NODE_9924_length_244_cov_2.299517_g9419_i0	PRJNA556842	9924	244	2.299517	5.61082148	Hymenobacter	89966	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g9419	i0	99.18	304.360655737705	244	2	100	0	1	244	271817	272060	Hymenobacter sp. DG01 chromosome, complete genome	blastn	74264	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01
5625682	5625682	PRJNA556842_P_NODE_16585_length_159_cov_2.680328_g16080_i0	PRJNA556842	16585	159	2.680328	4.26172152	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g16080	i0	100	479.056603773585	159	0	100	0	1	159	670006	670164	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	76170	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
6227807	6227807	PRJNA556842_P_NODE_14025_length_182_cov_1.055172_g13520_i0	PRJNA556842	14025	182	1.055172	1.92041304	Weeksellaceae	2762318	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g13520	i0	100	34.9010989010989	182	0	100	0	1	182	2100962	2100781	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	6352	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
7502297	7502297	PRJNA556842_P_NODE_1486_length_855_cov_13.232274_g1133_i0	PRJNA556842	1486	855	13.232274	113.1359427	Prevotella	838	Bacteria	Bacteria	1367	0	NTclustered	gi\|2028882546\|gb\|CP072373.1\|	28129	g1133	i0	95.556	212.154385964912	855	37	100	1	1	855	95804	96657	Prevotella denticola strain F0119 chromosome, complete genome	blastn	181392	1367	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella denticola
7502302	7502302	PRJNA556842_P_NODE_3226_length_543_cov_5.679842_g2758_i0	PRJNA556842	3226	543	5.679842	30.84154206	Weeksellaceae	2762318	Bacteria	Bacteria	953	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g2758	i0	99.06	517.629834254144	532	4	98	1	12	543	2157778	2158308	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	281073	959	0.993743482794578	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
8777085	8777085	PRJNA556842_P_NODE_16947_length_157_cov_1.300000_g16442_i0	PRJNA556842	16947	157	1.3	2.041	Cloacibacterium	501783	Bacteria	Bacteria	278	1.96e-70	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g16442	i0	98.718	4.98726114649681	156	2	99	0	1	156	2749710	2749555	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	783	279	0.996415770609319	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
11327263	11327263	PRJNA556842_P_NODE_2529_length_629_cov_8.574324_g2102_i0	PRJNA556842	2529	629	8.574324	53.93249796	Prevotella	838	Bacteria	Bacteria	1022	0	NTclustered	gi\|2028882546\|gb\|CP072373.1\|	28129	g2102	i0	96.025	215.001589825119	629	24	100	1	1	629	96346	96973	Prevotella denticola strain F0119 chromosome, complete genome	blastn	135236	1022	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella denticola
12603118	12603118	PRJNA556842_P_NODE_6570_length_338_cov_2.787375_g6067_i0	PRJNA556842	6570	338	2.787375	9.4213275	Weeksellaceae	2762318	Bacteria	Bacteria	569	7.119999999999998e-158	NTclustered	gi\|1497470369\|gb\|CP023540.1\|	2039166	g6067	i0	97.041	489.692307692308	338	10	100	0	1	338	628818	629155	Chryseobacterium sp. 6424 chromosome, complete genome	blastn	165516	569	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. 6424
12603119	12603119	PRJNA556842_P_NODE_6890_length_326_cov_11.411765_g6387_i0	PRJNA556842	6890	326	11.411765	37.2023539	root	1	Root_unresolved	Root_unresolved	597	3.139999999999999e-166	NTclustered	gi\|1139277798\|emb\|LT691819.1\|	28133	g6387	i0	99.693	104	326	1	100	0	1	326	326	1	Prevotella nigrescens partial 16S rRNA gene, isolate 520N_17236	blastn	33904	597	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
13878110	13878110	PRJNA556842_P_NODE_10691_length_229_cov_4.010417_g10186_i0	PRJNA556842	10691	229	4.010417	9.18385493	Cloacibacterium	501783	Bacteria	Bacteria	396	8.1899999999999985e-106	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g10186	i0	97.817	466.593886462882	229	5	100	0	1	229	1872333	1872561	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	106850	396	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
14550818	14550818	PRJNA556842_P_NODE_12392_length_202_cov_0.866667_g11887_i0	PRJNA556842	12392	202	0.866667	1.75066734	Bacteroides intestinalis	329854	Bacteria	Bacteria	167	6.02e-37	NTclustered	gi\|1707809164\|gb\|CP041379.1\|	329854	g11887	i0	88.489	209.425742574257	139	15	68	1	65	202	2232224	2232086	Bacteroides intestinalis strain APC919/174 chromosome, complete genome	blastn	42304	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides intestinalis
15824540	15824540	PRJNA556842_P_NODE_11253_length_219_cov_1.862637_g10748_i0	PRJNA556842	11253	219	1.862637	4.07917503	Niabella soli	446683	Bacteria	Bacteria	344	2.85e-90	NTclustered	gi\|570743502\|gb\|CP007035.1\|	929713	g10748	i0	94.977	288.570776255708	219	11	100	0	1	219	2224386	2224168	Niabella soli DSM 19437, complete genome	blastn	63197	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella soli
15824544	15824544	PRJNA556842_P_NODE_15733_length_166_cov_1.798450_g15228_i0	PRJNA556842	15733	166	1.79845	2.985427	Filimonas lacunae	477680	Bacteria	Bacteria	231	1.6599999999999998e-56	NTclustered	gi\|1031978622\|dbj\|AP017422.1\|	477680	g15228	i0	91.765	59.8614457831325	170	8	100	6	1	166	311144	310977	Filimonas lacunae DNA, complete genome, strain: NBRC 104114	blastn	9937	231	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Filimonas	Filimonas lacunae
15824556	15824556	PRJNA556842_P_NODE_8353_length_281_cov_5.893443_g7848_i0	PRJNA556842	8353	281	5.893443	16.56057483	Prevotella multiformis	282402	Bacteria	Bacteria	514	2.75e-141	NTclustered	gi\|2028862730\|gb\|CP072357.1\|	282402	g7848	i0	99.644	224.316725978648	281	1	100	0	1	281	5029	5309	Prevotella multiformis strain F0096 chromosome 1, complete sequence	blastn	63033	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella multiformis
17099342	17099342	PRJNA556842_P_NODE_6654_length_335_cov_1.419463_g6151_i0	PRJNA556842	6654	335	1.419463	4.75520105	Tannerella serpentiformis	712710	Bacteria	Bacteria	486	7.31e-133	NTclustered	gi\|1379127804\|gb\|CP017038.2\|	712710	g6151	i0	95.987	425.253731343284	299	12	89	0	37	335	559573	559871	Tannerella serpentiformis strain W11667 chromosome, complete genome	blastn	142460	486	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella serpentiformis
19648138	19648138	PRJNA556842_P_NODE_16456_length_160_cov_2.959350_g15951_i0	PRJNA556842	16456	160	2.95935	4.73496	Chryseobacterium sp. 6424	2039166	Bacteria	Bacteria	291	2.5799999999999998e-74	NTclustered	gi\|1497470369\|gb\|CP023540.1\|	2039166	g15951	i0	99.375	327.9	160	1	100	0	1	160	629280	629439	Chryseobacterium sp. 6424 chromosome, complete genome	blastn	52464	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. 6424
19648145	19648145	PRJNA556842_P_NODE_9676_length_249_cov_2.627358_g9171_i0	PRJNA556842	9676	249	2.627358	6.54212142	Hymenobacter sp. DG01	2584940	Bacteria	Bacteria	353	5.52e-93	NTclustered	gi\|1686076296\|gb\|CP040936.1\|	2584940	g9171	i0	92.369	315.570281124498	249	18	100	1	1	249	270967	271214	Hymenobacter sp. DG01 chromosome, complete genome	blastn	78577	353	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG01
23474220	23474220	PRJNA556842_P_NODE_15319_length_170_cov_1.248120_g14814_i0	PRJNA556842	15319	170	1.24812	2.121804	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	261	2.1700000000000002e-65	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g14814	i0	94.643	306.529411764706	168	9	99	0	3	170	442596	442763	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	52110	261	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275

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