metadata: contig_metadata: 11 rows where bioproject = "PRJNA773625" and tax

11 rows where bioproject = "PRJNA773625" 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
749196	749196	PRJNA773625_P_NODE_10441_length_163_cov_0.912281_g10426_i0	PRJNA773625	10441	163	0.912281	1.48701803	Cloacibacterium caeni	2004710	Bacteria	Bacteria	198	1.6499999999999999e-46	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g10426	i0	93.284	3.52147239263804	134	9	82	0	27	160	712436	712569	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	574	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
5852914	5852914	PRJNA773625_P_NODE_7645_length_168_cov_0.873950_g7630_i0	PRJNA773625	7645	168	0.87395	1.468236	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g7630	i0	100	6.57142857142857	168	0	100	0	1	168	195364	195531	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	1104	311	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
9677848	9677848	PRJNA773625_P_NODE_9568_length_165_cov_0.896552_g9553_i0	PRJNA773625	9568	165	0.896552	1.4793108	Segatella copri	165179	Bacteria	Bacteria	259	7.57e-65	NTclustered	gi\|2733781693\|gb\|CP152350.1\|	165179	g9553	i0	95.152	31.6424242424242	165	7	99	1	2	165	2420728	2420564	Segatella copri strain HDA03 chromosome, complete genome	blastn	5221	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
21151906	21151906	PRJNA773625_P_NODE_6797_length_172_cov_1.471545_g6782_i0	PRJNA773625	6797	172	1.471545	2.5310574	Cellulophaga sp. BC115SP	2683263	Bacteria	Bacteria	80.9	5.24e-16	NR	WP_166550734.1	2683263	g6782	i0	100	0.680232558139535	39	0	68	0	147	31	954	992	WP_166550734.1 PAS domain S-box protein [Cellulophaga sp. BC115SP]	diamond	117	80.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. BC115SP
21151950	21151950	PRJNA773625_P_NODE_8297_length_167_cov_0.881356_g8282_i0	PRJNA773625	8297	167	0.881356	1.47186452	Segatella copri	165179	Bacteria	Bacteria	303	3.5e-78	NTclustered	gi\|2784148841\|gb\|CP156891.1\|	165179	g8282	i0	99.401	10.9760479041916	167	1	100	0	1	167	308367	308533	Segatella copri strain HDC01 chromosome 1	blastn	1833	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
22426522	22426522	PRJNA773625_P_NODE_10218_length_163_cov_0.912281_g10203_i0	PRJNA773625	10218	163	0.912281	1.48701803	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g10203	i0	100	1	163	0	100	0	1	163	261361	261523	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	163	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
22426535	22426535	PRJNA773625_P_NODE_10538_length_163_cov_0.912281_g10523_i0	PRJNA773625	10538	163	0.912281	1.48701803	Segatella copri	165179	Bacteria	Bacteria	268	1.24e-67	NTclustered	gi\|2784148841\|gb\|CP156891.1\|	165179	g10523	i0	96.319	11	163	6	100	0	1	163	553518	553356	Segatella copri strain HDC01 chromosome 1	blastn	1793	268	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
29610883	29610883	PRJNA773625_P_NODE_8630_length_166_cov_1.213675_g8615_i0	PRJNA773625	8630	166	1.213675	2.0147005	Cellulophaga sp. BC115SP	2683263	Bacteria	Bacteria	117	1.51e-30	NR	WP_370520429.1	2683263	g8615	i0	96.4	0.993975903614458	55	2	99.4	0	1	165	62	116	WP_370520429.1 helix-turn-helix domain-containing protein [Cellulophaga sp. BC115SP]	diamond	165	117	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. BC115SP
30306589	30306589	PRJNA773625_P_NODE_8212_length_167_cov_0.881356_g8197_i0	PRJNA773625	8212	167	0.881356	1.47186452	Pontibacter virosus	1765052	Bacteria	Bacteria	80.9	1.6e-17	NR	WP_116541989.1	1765052	g8197	i0	73.1	0.934131736526946	52	14	93.4	0	156	1	1	52	WP_116541989.1 hypothetical protein [Pontibacter virosus]	diamond	156	80.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter virosus
30473752	30473752	PRJNA773625_P_NODE_8713_length_166_cov_0.888889_g8698_i0	PRJNA773625	8713	166	0.888889	1.47555574	Bacteroidota	976	Bacteria	Bacteria	87.4	8.26e-19	NR	WP_044171645.1	103	g8698	i0	95.7	1.66265060240964	46	2	83.1	0	3	140	184	229	WP_044171645.1 hypothetical protein [Flectobacillus major]	diamond	276	87.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus major
31538871	31538871	PRJNA773625_P_NODE_10776_length_162_cov_0.920354_g10761_i0	PRJNA773625	10776	162	0.920354	1.49097348	Cellulophaga sp. BC115SP	2683263	Bacteria	Bacteria	52.4	1.34e-6	NR	WP_166551959.1	2683263	g10761	i0	96.2	0.481481481481481	26	1	48.1	0	96	19	1	26	WP_166551959.1 MarR family winged helix-turn-helix transcriptional regulator [Cellulophaga sp. BC115SP]	diamond	78	52.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. BC115SP

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