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

9 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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
2770263	2770263	PRJNA1112809_P_NODE_160123_length_254_cov_1.679558_g156848_i0	PRJNA1112809	160123	254	1.679558	4.26607732	Fusobacterium mortiferum	850	Bacteria	Bacteria	379	9.31e-101	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g156848	i0	94.048	522.062992125984	252	11	99	4	2	253	104243	103996	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	132604	379	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
6599463	6599463	PRJNA1112809_P_NODE_73346_length_406_cov_3.126126_g70071_i0	PRJNA1112809	73346	406	3.126126	12.69207156	Cetobacterium somerae	188913	Bacteria	Bacteria	713	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g70071	i0	98.519	474.852216748768	405	5	99	1	2	406	49350	48947	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	192790	713	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14248575	14248575	PRJNA1112809_P_NODE_157872_length_256_cov_1.683060_g154597_i0	PRJNA1112809	157872	256	1.68306	4.3086336	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	473	4.189999999999999e-129	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g154597	i0	100	431.24609375	256	0	100	0	1	256	967932	968187	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	110399	473	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
15051107	15051107	PRJNA1112809_P_NODE_201512_length_199_cov_4.444444_g198237_i0	PRJNA1112809	201512	199	4.444444	8.84444356	Fusobacterium	848	Bacteria	Bacteria	368	1.51e-97	NTclustered	gi\|1948622963\|gb\|CP066022.1\|	285729	g198237	i0	100	99.5175879396985	199	0	100	0	1	199	2052631	2052829	Fusobacterium canifelinum strain FDAARGOS_999 chromosome, complete genome	blastn	19804	368	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium canifelinum
16797088	16797088	PRJNA1112809_P_NODE_179234_length_246_cov_0.890173_g175959_i0	PRJNA1112809	179234	246	0.890173	2.18982558	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g175959	i0	99.593	369.29674796748	246	1	100	0	1	246	53853	53608	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	90847	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
20149792	20149792	PRJNA1112809_P_NODE_191116_length_242_cov_0.911243_g187841_i0	PRJNA1112809	191116	242	0.911243	2.20520806	Cetobacterium	180162	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g187841	i0	99.587	510.789256198347	242	1	100	0	1	242	279102	279343	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	123611	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21896822	21896822	PRJNA1112809_P_NODE_177458_length_246_cov_1.693642_g174183_i0	PRJNA1112809	177458	246	1.693642	4.16635932	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g174183	i0	98.78	3.08943089430894	246	3	100	0	1	246	819710	819465	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	760	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
22700244	22700244	PRJNA1112809_P_NODE_169178_length_249_cov_1.488636_g165903_i0	PRJNA1112809	169178	249	1.488636	3.70670364	Fusobacterium	848	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1721134154\|emb\|LR698955.1\|	851	g165903	i0	100	72.004016064257	249	0	100	0	1	249	320373	320621	Fusobacterium nucleatum isolate MGYG-HGUT-01347 genome assembly, chromosome: 1	blastn	17929	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
23171689	23171689	PRJNA1112809_P_NODE_144719_length_269_cov_1.030612_g141444_i0	PRJNA1112809	144719	269	1.030612	2.77234628	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	486	5.699999999999999e-133	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g141444	i0	99.257	405.308550185874	269	2	100	0	1	269	52835	53103	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	109028	486	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212

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