metadata: contig_metadata: 6 rows where bioproject = "PRJEB27957" and tax

6 rows where bioproject = "PRJEB27957" 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
23399	23399	PRJEB27957_P_NODE_33281_length_271_cov_2.342342_g33171_i0	PRJEB27957	33281	271	2.342342	6.34774682	Cetobacterium somerae	188913	Bacteria	Bacteria	466	7.49e-127	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g33171	i0	97.786	361.232472324723	271	5	100	1	1	271	1318738	1318469	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	97894	466	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6089950	6089950	PRJEB27957_P_NODE_69025_length_204_cov_1.341935_g68915_i0	PRJEB27957	69025	204	1.341935	2.7375474	Cetobacterium	180162	Bacteria	Bacteria	377	2.59e-100	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g68915	i0	100	529	204	0	100	0	1	204	280201	280404	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	107916	377	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9914947	9914947	PRJEB27957_P_NODE_1208_length_845_cov_2.007538_g1147_i0	PRJEB27957	1208	845	2.007538	16.9636961	Cetobacterium	180162	Bacteria	Bacteria	1528	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g1147	i0	99.29	522.49349112426	845	6	100	0	1	845	278717	279561	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	441507	1528	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16600262	16600262	PRJEB27957_P_NODE_98234_length_173_cov_1.661290_g98124_i0	PRJEB27957	98234	173	1.66129	2.8740317	uncultured Ilyobacter sp.	544433	Bacteria	Bacteria	58.4	3.12e-4	NTclustered	gi\|2621703980\|emb\|OY762935.1\|	544433	g98124	i0	97.143	0.202312138728324	35	0	20	1	21	55	1005229	1005262	MAG: uncultured Ilyobacter sp. isolate b034904b-4944-4ecc-b743-47c946c9bc96 genome assembly, chromosome: 1	blastn	35	58.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Ilyobacter	uncultured Ilyobacter sp.
20424138	20424138	PRJEB27957_P_NODE_87537_length_184_cov_1.155556_g87427_i0	PRJEB27957	87537	184	1.155556	2.12622304	Leptotrichia mesophila	3239303	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2785242249\|gb\|CP165646.1\|	3239303	g87427	i0	100	0.157608695652174	29	0	16	0	155	183	1003494	1003522	Leptotrichia sp. HSP-342 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia mesophila
22975397	22975397	PRJEB27957_P_NODE_79299_length_192_cov_1.454545_g79189_i0	PRJEB27957	79299	192	1.454545	2.7927264	Cetobacterium somerae	188913	Bacteria	Bacteria	344	2.44e-90	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g79189	i0	98.958	424.40625	192	2	100	0	1	192	1318739	1318930	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	81486	344	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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