metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1022392" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1022392" 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
5265202	5265202	PRJNA1022392_P_NODE_58225_length_179_cov_3.484848_g57556_i0	PRJNA1022392	58225	179	3.484848	6.23787792	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	315	1.75e-81	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g57556	i0	98.333	2.0111731843575398	180	2	100	1	1	179	2101836	2102015	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	360	315	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
10365287	10365287	PRJNA1022392_P_NODE_37469_length_204_cov_3.229299_g36800_i0	PRJNA1022392	37469	204	3.229299	6.58776996	Leptotrichia hofstadii	157688	Bacteria	Bacteria	259	9.77e-65	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g36800	i0	87.736	19.7745098039216	212	18	100	1	1	204	2484529	2484740	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	4034	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
11207049	11207049	PRJNA1022392_P_NODE_27509_length_206_cov_5.213836_g26840_i0	PRJNA1022392	27509	206	5.213836	10.74050216	Fusobacterium	848	Bacteria	Bacteria	176	1.02e-39	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g26840	i0	98.98	83.5	98	1	95	0	1	98	77890	77987	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	17201	176	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
11207072	11207072	PRJNA1022392_P_NODE_31749_length_206_cov_3.119497_g31080_i0	PRJNA1022392	31749	206	3.119497	6.42616382	Fusobacterium	848	Bacteria	Bacteria	198	2.19e-46	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g31080	i0	82.511	40.4320388349515	223	22	100	9	1	206	1711502	1711280	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	8329	198	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
11640830	11640830	PRJNA1022392_P_NODE_47010_length_193_cov_3.609589_g46341_i0	PRJNA1022392	47010	193	3.609589	6.96650677	Fusobacterium polymorphum	76857	Bacteria	Bacteria	183	5.6499999999999996e-42	NTclustered	gi\|2706041172\|gb\|CP056018.1\|	76857	g46341	i0	100	63.139896373057	99	0	99	0	1	99	886983	887081	Fusobacterium polymorphum strain SB006 chromosome, complete genome	blastn	12186	183	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
12482805	12482805	PRJNA1022392_P_NODE_59510_length_178_cov_1.290076_g58841_i0	PRJNA1022392	59510	178	1.290076	2.29633528	Leptotrichia	32067	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|285176642\|gb\|GU415711.1\|	40542	g58841	i0	99.438	111.926966292135	178	1	100	0	1	178	7	184	Leptotrichia buccalis clone GT056 16S ribosomal RNA gene, partial sequence	blastn	19923	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
12915635	12915635	PRJNA1022392_P_NODE_25791_length_207_cov_4.387500_g25122_i0	PRJNA1022392	25791	207	4.3875	9.082125	Fusobacterium polymorphum	76857	Bacteria	Bacteria	183	6.16e-42	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g25122	i0	100	50.5314009661836	99	0	95	0	109	207	2006504	2006406	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	10460	183	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
15464959	15464959	PRJNA1022392_P_NODE_45513_length_194_cov_3.721088_g44844_i0	PRJNA1022392	45513	194	3.721088	7.21891072	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	248	1.99e-61	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g44844	i0	89.252	7.72164948453608	214	1	99	1	3	194	2218891	2219104	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	1498	248	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
19287807	19287807	PRJNA1022392_P_NODE_40196_length_196_cov_4.181208_g39527_i0	PRJNA1022392	40196	196	4.181208	8.19516768	Leptotrichia hofstadii	157688	Bacteria	Bacteria	171	4.49e-38	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g39527	i0	97.959	3.96428571428571	98	2	100	0	1	98	1229653	1229556	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	777	171	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
21406091	21406091	PRJNA1022392_P_NODE_73417_length_162_cov_2.139130_g72748_i0	PRJNA1022392	73417	162	2.13913	3.4653906	Leptotrichia	32067	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g72748	i0	100	394.827160493827	162	0	100	0	1	162	198348	198509	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	63962	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
21839080	21839080	PRJNA1022392_P_NODE_47118_length_193_cov_3.226027_g46449_i0	PRJNA1022392	47118	193	3.226027	6.22623211	Sneathia vaginalis	187101	Bacteria	Bacteria	58.4	3.58e-4	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g46449	i0	100	1.10362694300518	31	0	16	0	59	89	877332	877362	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	213	58.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis

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