metadata: contig_metadata: 10 rows where bioproject = "PRJEB15333" and tax

10 rows where bioproject = "PRJEB15333" and tax_kingdom = "Fusobacteriati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1295809	1295809	PRJEB15333_P_NODE_17442_length_168_cov_0.873950_g17358_i0	PRJEB15333	17442	168	0.87395	1.468236	Cetobacterium somerae	188913	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g17358	i0	100	4.94047619047619	166	0	99	0	3	168	398466	398301	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	830	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7363536	7363536	PRJEB15333_P_NODE_7326_length_246_cov_2.030457_g7242_i0	PRJEB15333	7326	246	2.030457	4.99492422	Cetobacterium	180162	Bacteria	Bacteria	418	1.9e-112	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g7242	i0	97.925	12.719512195122	241	5	98	0	6	246	1904292	1904052	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3129	418	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8638927	8638927	PRJEB15333_P_NODE_20687_length_162_cov_0.920354_g20603_i0	PRJEB15333	20687	162	0.920354	1.49097348	Cetobacterium	180162	Bacteria	Bacteria	283	4.39e-72	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g20603	i0	98.148	19	162	3	100	0	1	162	1906275	1906436	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3078	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9914003	9914003	PRJEB15333_P_NODE_19588_length_164_cov_0.904348_g19504_i0	PRJEB15333	19588	164	0.904348	1.48313072	Cetobacterium	180162	Bacteria	Bacteria	195	2.15e-45	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g19504	i0	89.375	7.8780487804878	160	9	98	3	3	162	872117	871966	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1292	195	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14049746	14049746	PRJEB15333_P_NODE_17512_length_168_cov_0.873950_g17428_i0	PRJEB15333	17512	168	0.87395	1.468236	Cetobacterium somerae	188913	Bacteria	Bacteria	305	9.81e-79	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g17428	i0	100	6.875	165	0	98	0	4	168	1769118	1769282	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1155	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18837643	18837643	PRJEB15333_P_NODE_21035_length_160_cov_2.099099_g20951_i0	PRJEB15333	21035	160	2.099099	3.3585584	Cetobacterium	180162	Bacteria	Bacteria	263	5.629999999999999e-66	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g20951	i0	96.273	5.03125	161	5	100	1	1	160	1303567	1303407	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	805	263	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21698327	21698327	PRJEB15333_P_NODE_17518_length_168_cov_0.873950_g17434_i0	PRJEB15333	17518	168	0.87395	1.468236	Cetobacterium somerae	188913	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g17434	i0	100	5	168	0	100	0	1	168	587102	586935	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	840	311	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
27311439	27311439	PRJEB15333_P_NODE_12983_length_190_cov_1.475177_g12899_i0	PRJEB15333	12983	190	1.475177	2.8028363	Cetobacterium	180162	Bacteria	Bacteria	120	1.43e-33	NR	WP_047395133.1	1339239	g12899	i0	100	1.92631578947368	61	0	96.3	0	2	184	46	106	WP_047395133.1 sigma-70 family RNA polymerase sigma factor, partial [Cetobacterium sp. ZOR0034]	diamond	366	120	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
32246431	32246431	PRJEB15333_P_NODE_18638_length_166_cov_0.888889_g18554_i0	PRJEB15333	18638	166	0.888889	1.47555574	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	91.7	2.17e-21	NR	WP_294095306.1	527638	g18554	i0	97.8	0.831325301204819	46	1	83.1	0	3	140	150	195	WP_294095306.1 TIGR03936 family radical SAM-associated protein [uncultured Cetobacterium sp.]	diamond	138	91.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
32719988	32719988	PRJEB15333_P_NODE_8200_length_234_cov_1.627027_g8116_i0	PRJEB15333	8200	234	1.627027	3.80724318	unclassified Cetobacterium	2630983	Bacteria	Bacteria	150	3.49e-45	NR	WP_047383851.1	2630983	g8116	i0	100	0.974358974358974	76	0	97.4	0	233	6	39	114	WP_047383851.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium]	diamond	228	150	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium

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