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

11 rows where analysis = "blastn", bioproject = "PRJNA627467" 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
1875238	1875238	PRJNA627467_P_NODE_14462_length_172_cov_4.341463_g14393_i0	PRJNA627467	14462	172	4.341463	7.46731636	Leptotrichia wadei	157687	Bacteria	Bacteria	296	6.04e-76	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g14393	i0	99.387	72.8720930232558	163	1	95	0	4	166	221672	221834	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	12534	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
2425973	2425973	PRJNA627467_P_NODE_17002_length_165_cov_5.017241_g16933_i0	PRJNA627467	17002	165	5.017241	8.27844765	Fusobacterium	848	Bacteria	Bacteria	292	7.47e-75	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g16933	i0	100	486.557575757576	158	0	96	0	8	165	156192	156349	Fusobacterium varium strain SB069 chromosome	blastn	80282	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
6977577	6977577	PRJNA627467_P_NODE_13246_length_176_cov_11.811024_g13177_i0	PRJNA627467	13246	176	11.811024	20.78740224	Fusobacterium varium	856	Bacteria	Bacteria	226	8.269999999999997e-55	NTclustered	gi\|1540073569\|emb\|LR134390.1\|	856	g13177	i0	90.341	399.647727272727	176	11	98	6	1	173	514392	514220	Fusobacterium varium strain NCTC10560 genome assembly, chromosome: 1	blastn	70338	226	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
7528497	7528497	PRJNA627467_P_NODE_1006_length_364_cov_4.219048_g939_i0	PRJNA627467	1006	364	4.219048	15.35733472	Fusobacterium	848	Bacteria	Bacteria	603	7.599999999999998e-168	NTclustered	gi\|2704957570\|gb\|CP077164.1\|	851	g939	i0	97.207	468.258241758242	358	6	98	4	6	361	127633	127278	Fusobacterium nucleatum strain SB049 chromosome, complete genome	blastn	170446	603	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
7528584	7528584	PRJNA627467_P_NODE_15886_length_168_cov_1.680672_g15817_i0	PRJNA627467	15886	168	1.680672	2.82352896	Leptotrichia	32067	Bacteria	Bacteria	292	7.64e-75	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g15817	i0	98.78	26.952380952381	164	2	98	0	5	168	499141	499304	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	4528	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
12629804	12629804	PRJNA627467_P_NODE_15710_length_168_cov_4.025210_g15641_i0	PRJNA627467	15710	168	4.02521	6.7623528	Fusobacterium	848	Bacteria	Bacteria	303	3.53e-78	NTclustered	gi\|2704993027\|gb\|CP077141.1\|	851	g15641	i0	100	472.488095238095	164	0	98	0	5	168	614163	614326	Fusobacterium nucleatum strain KCOM2902 chromosome, complete genome	blastn	79378	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
13353375	13353375	PRJNA627467_P_NODE_17071_length_165_cov_2.982759_g17002_i0	PRJNA627467	17071	165	2.982759	4.92155235	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	255	9.8e-64	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g17002	i0	96.178	66.7757575757576	157	5	95	1	9	165	51590	51745	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	11018	255	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14628084	14628084	PRJNA627467_P_NODE_16052_length_167_cov_3.881356_g15983_i0	PRJNA627467	16052	167	3.881356	6.48186452	Leptotrichia wadei	157687	Bacteria	Bacteria	298	1.63e-76	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g15983	i0	100	218.760479041916	161	0	96	0	5	165	2244286	2244126	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	36533	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
17177095	17177095	PRJNA627467_P_NODE_16534_length_166_cov_3.991453_g16465_i0	PRJNA627467	16534	166	3.991453	6.62581198	Fusobacterium mortiferum	850	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g16465	i0	100	507.120481927711	163	0	98	0	1	163	103937	104099	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	84182	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
22276315	22276315	PRJNA627467_P_NODE_20298_length_157_cov_2.490741_g20229_i0	PRJNA627467	20298	157	2.490741	3.91046337	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	283	4.22e-72	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g20229	i0	100	475.745222929936	153	0	97	0	1	153	71508	71356	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	74692	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
24825297	24825297	PRJNA627467_P_NODE_1520_length_322_cov_1.996337_g1452_i0	PRJNA627467	1520	322	1.996337	6.42820514	Fusobacterium animalis	76859	Bacteria	Bacteria	566	8.729999999999999e-157	NTclustered	gi\|2706049627\|gb\|CP077180.1\|	76859	g1452	i0	98.442	430.217391304348	321	5	99	0	2	322	197233	196913	Fusobacterium animalis strain SB034 chromosome, complete genome	blastn	138530	566	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis

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