metadata: contig_metadata: 12 rows where bioproject = "PRJEB12296" and tax

12 rows where bioproject = "PRJEB12296" 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
3846939	3846939	PRJEB12296_P_NODE_304_length_229_cov_35.190000_g291_i0	PRJEB12296	304	229	35.19	80.5851	Cetobacterium somerae	188913	Bacteria	Bacteria	364	2.309999999999999e-96	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g291	i0	98.551	428.109170305677	207	2	90	1	1	206	1318782	1318988	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	98037	364	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25606825	25606825	PRJEB12296_S_NODE_17_length_1101_cov_18.607880_g13_i0	PRJEB12296	17	1101	18.60788	204.8727588	Cetobacterium	180162	Bacteria	Bacteria	1953	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g13	i0	98.64	518.94732061762	1103	13	100	2	1	1101	278631	279733	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	571361	1953	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25636475	25636475	PRJEB12296_S_NODE_1266_length_340_cov_12184.544262_g1234_i0	PRJEB12296	1266	340	12184.544262	41427.4504908	Leptotrichia buccalis C-1	40542	Bacteria	Bacteria	490	5.74e-134	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g1234	i0	98.214	399.847058823529	280	5	82	0	61	340	265932	265653	Leptotrichia buccalis DSM 1135, complete genome	blastn	135948	490	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
25878786	25878786	PRJEB12296_S_NODE_1171_length_348_cov_17541.753994_g1139_i0	PRJEB12296	1171	348	17541.753994	61045.30389912	Cetobacterium	180162	Bacteria	Bacteria	490	5.89e-134	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g1139	i0	100	411.505747126437	265	0	76	0	13	277	280514	280778	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	143204	490	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25878829	25878829	PRJEB12296_S_NODE_27_length_1004_cov_19.347781_g13_i1	PRJEB12296	27	1004	19.347781	194.25172124	Cetobacterium	180162	Bacteria	Bacteria	1541	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g13	i1	95.473	483.888446215139	972	33	96	10	39	1004	278767	279733	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	485824	1541	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25878840	25878840	PRJEB12296_S_NODE_4443_length_220_cov_30.708108_g4411_i0	PRJEB12296	4443	220	30.708108	67.5578376	Leptotrichia	32067	Bacteria	Bacteria	370	4.74e-98	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g4411	i0	99.507	243.781818181818	203	1	92	0	1	203	203	1	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	53632	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
25908883	25908883	PRJEB12296_S_NODE_1876_length_300_cov_7550.833962_g1844_i0	PRJEB12296	1876	300	7550.833962	22652.501886	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	438	1.8299999999999998e-118	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g1844	i0	99.583	204.066666666667	240	1	80	0	26	265	197217	196978	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	61220	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
26151261	26151261	PRJEB12296_S_NODE_10717_length_170_cov_1.688889_g10685_i0	PRJEB12296	10717	170	1.688889	2.8711113	Cetobacterium	180162	Bacteria	Bacteria	220	3.68e-53	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g10685	i0	97.656	46.0764705882353	128	3	78	0	1	128	1814890	1815017	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	7833	220	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26181161	26181161	PRJEB12296_S_NODE_254_length_550_cov_385.149515_g232_i0	PRJEB12296	254	550	385.149515	2118.3223325	Cetobacterium somerae	188913	Bacteria	Bacteria	865	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g232	i0	98.768	436.978181818182	487	5	89	1	30	516	49354	48869	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	240338	865	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26287295	26287295	PRJEB12296_S_NODE_4942_length_212_cov_5134.790960_g4910_i0	PRJEB12296	4942	212	5134.79096	10885.7568352	Cetobacterium	180162	Bacteria	Bacteria	191	3.79e-44	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g4910	i0	95.041	23.0943396226415	121	6	57	0	57	177	1903119	1902999	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4896	191	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26559177	26559177	PRJEB12296_S_NODE_12928_length_163_cov_81.062500_g12896_i0	PRJEB12296	12928	163	81.0625	132.131875	Cetobacterium	180162	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g12896	i0	100	510	163	0	100	0	1	163	279821	279983	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	83130	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
32993613	32993613	PRJEB12296_S_NODE_4987_length_212_cov_1.949153_g4955_i0	PRJEB12296	4987	212	1.949153	4.13220436	unclassified Cetobacterium	2630983	Bacteria	Bacteria	63.9	4.25e-11	NR	WP_047381601.1	2630983	g4955	i0	98.2	0.792452830188679	56	1	79.2	0	211	44	37	92	WP_047381601.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium]	diamond	168	63.9	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);;