metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1150539" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1150539" 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
301164	301164	PRJNA1150539_S_NODE_38081_length_334_cov_1.398467_g37485_i0	PRJNA1150539	38081	334	1.398467	4.67087978	Leptotrichia hofstadii	157688	Bacteria	Bacteria	577	4.199999999999999e-160	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g37485	i0	97.91	291.556886227545	335	4	100	3	1	334	499485	499153	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	97380	577	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
301260	301260	PRJNA1150539_S_NODE_46861_length_316_cov_5.641975_g46265_i0	PRJNA1150539	46861	316	5.641975	17.828641	uncultured Ilyobacter sp.	544433	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|2621717559\|emb\|OY775911.1\|	544433	g46265	i0	100	0.265822784810127	28	0	9	0	33	60	1256796	1256823	MAG: uncultured Ilyobacter sp. isolate 988a6a11-b556-497a-8909-2adea115d691 genome assembly, chromosome: 1	blastn	84	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Ilyobacter	uncultured Ilyobacter sp.
11239877	11239877	PRJNA1150539_S_NODE_104309_length_238_cov_2.503030_g103713_i0	PRJNA1150539	104309	238	2.50303	5.9572114	Fusobacterium	848	Bacteria	Bacteria	374	4.02e-99	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g103713	i0	94.958	18.936974789916	238	12	100	0	1	238	213516	213753	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	4507	374	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
11240008	11240008	PRJNA1150539_S_NODE_39329_length_331_cov_2.825581_g38733_i0	PRJNA1150539	39329	331	2.825581	9.35267311	Leptotrichia	32067	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g38733	i0	100	0.253776435045317	28	0	8	0	273	300	174403	174376	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	84	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
13054932	13054932	PRJNA1150539_S_NODE_39631_length_330_cov_5.357977_g39035_i0	PRJNA1150539	39631	330	5.357977	17.6813241	Leptotrichia wadei	157687	Bacteria	Bacteria	603	6.839999999999998e-168	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g39035	i0	99.696	207.521212121212	329	1	99	0	2	330	2299144	2298816	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	68482	603	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
18153484	18153484	PRJNA1150539_S_NODE_86695_length_257_cov_3.451087_g86099_i0	PRJNA1150539	86695	257	3.451087	8.86929359	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|1276707709\|gb\|CP024699.1\|	2663009	g86099	i0	100	88.9066147859922	257	0	100	0	1	257	1778609	1778353	Fusobacterium pseudoperiodonticum strain KCOM 1261 chromosome, complete genome	blastn	22849	475	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
18888209	18888209	PRJNA1150539_S_NODE_2075_length_928_cov_4.247953_g1606_i0	PRJNA1150539	2075	928	4.247953	39.42100384	Fusobacterium	848	Bacteria	Bacteria	1670	0	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g1606	i0	99.138	490.009698275862	928	8	100	0	1	928	177512	176585	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	454729	1670	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
20702985	20702985	PRJNA1150539_S_NODE_68577_length_281_cov_5.081731_g67981_i0	PRJNA1150539	68577	281	5.0817310000000004	14.27966411	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	486	5.989999999999999e-133	NTclustered	gi\|1276716588\|gb\|CP024703.1\|	2663009	g67981	i0	97.865	11.9430604982206	281	6	100	0	1	281	248453	248173	Fusobacterium pseudoperiodonticum strain KCOM 2305 chromosome, complete genome	blastn	3356	486	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
23988806	23988806	PRJNA1150539_S_NODE_108179_length_229_cov_3.487179_g107583_i0	PRJNA1150539	108179	229	3.487179	7.98563991	Leptotrichia	32067	Bacteria	Bacteria	412	8.13e-111	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g107583	i0	99.127	86.6812227074236	229	2	100	0	1	229	2256929	2257157	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	19850	412	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
24527512	24527512	PRJNA1150539_S_NODE_67720_length_283_cov_1.247619_g67124_i0	PRJNA1150539	67720	283	1.247619	3.53076177	Fusobacterium periodonticum	860	Bacteria	Bacteria	483	7.809999999999997e-132	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g67124	i0	97.518	99.6890459363958	282	7	99	0	2	283	648828	649109	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	28212	483	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum

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