metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA680334" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA680334" 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
12648538	12648538	PRJNA680334_S_NODE_29150_length_227_cov_1.731959_g28664_i0	PRJNA680334	29150	227	1.731959	3.93154693	Fusobacterium	848	Bacteria	Bacteria	383	6.31e-102	NTclustered	gi\|2704993027\|gb\|CP077141.1\|	851	g28664	i0	99.524	53.0352422907489	210	1	93	0	18	227	2075088	2075297	Fusobacterium nucleatum strain KCOM2902 chromosome, complete genome	blastn	12039	383	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
15952454	15952454	PRJNA680334_S_NODE_37773_length_209_cov_4.619318_g37287_i0	PRJNA680334	37773	209	4.619318	9.65437462	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	272	1.29e-68	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g37287	i0	91.414	1.94736842105263	198	17	95	0	12	209	1054312	1054115	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	407	272	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
17227718	17227718	PRJNA680334_S_NODE_37854_length_209_cov_3.539773_g37368_i0	PRJNA680334	37854	209	3.539773	7.39812557	Leptotrichia buccalis	40542	Bacteria	Bacteria	381	2.0599999999999996e-101	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g37368	i0	99.522	67.6937799043062	209	1	100	0	1	209	240444	240652	Leptotrichia buccalis DSM 1135, complete genome	blastn	14148	381	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
17228601	17228601	PRJNA680334_S_NODE_9034_length_324_cov_2.965636_g8548_i0	PRJNA680334	9034	324	2.965636	9.60866064	Fusobacterium ulcerans	861	Bacteria	Bacteria	169	2.9e-37	NTclustered	gi\|1370545701\|gb\|CP028105.1\|	861	g8548	i0	81.019	2.09259259259259	216	37	66	4	1	214	2612443	2612230	Fusobacterium ulcerans strain ATCC 49185 chromosome, complete genome	blastn	678	169	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium ulcerans
19777397	19777397	PRJNA680334_S_NODE_87696_length_160_cov_3.196850_g87210_i0	PRJNA680334	87696	160	3.19685	5.11496	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	250	4.38e-62	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g87210	i0	95	14.38125	160	7	100	1	1	160	1937525	1937367	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2301	250	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
20295638	20295638	PRJNA680334_S_NODE_44436_length_199_cov_2.909639_g43950_i0	PRJNA680334	44436	199	2.909639	5.79018161	Streptobacillus	34104	Bacteria	Bacteria	318	1.54e-82	NTclustered	gi\|470485174\|ref\|NR_076688.1\|	34105	g43950	i0	95.5	102.085427135678	200	8	100	1	1	199	163	362	Streptobacillus moniliformis strain DSM 12112 23S ribosomal RNA gene, complete sequence	blastn	20315	318	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
20295664	20295664	PRJNA680334_S_NODE_54156_length_187_cov_2.733766_g53670_i0	PRJNA680334	54156	187	2.733766	5.11214242	Leptotrichia	32067	Bacteria	Bacteria	252	1.47e-62	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g53670	i0	90.909	17.3903743315508	187	17	100	0	1	187	2405420	2405234	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	3252	252	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
22327224	22327224	PRJNA680334_S_NODE_48418_length_194_cov_1.366460_g47932_i0	PRJNA680334	48418	194	1.36646	2.6509324	Fusobacterium polymorphum	76857	Bacteria	Bacteria	298	1.95e-76	NTclustered	gi\|2706501641\|gb\|CP084157.1\|	76857	g47932	i0	94.33	2.9639175257732	194	11	100	0	1	194	1736892	1737085	Fusobacterium polymorphum strain KCOM2446 chromosome, complete genome	blastn	575	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
24876315	24876315	PRJNA680334_S_NODE_66900_length_175_cov_1.838028_g66414_i0	PRJNA680334	66900	175	1.838028	3.216549	Leptotrichia hofstadii	157688	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g66414	i0	100	474.142857142857	175	0	100	0	1	175	577182	577356	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	82975	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii

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