metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA615351" 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
8249109	8249109	PRJNA615351_P_NODE_76047_length_453_cov_2.863636_g62042_i0	PRJNA615351	76047	453	2.863636	12.97227108	Leptotrichia wadei	157687	Bacteria	Bacteria	756	0	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g62042	i0	98.152	318.437086092715	433	8	96	0	21	453	221494	221926	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	144252	756	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
14624536	14624536	PRJNA615351_P_NODE_176812_length_159_cov_1.016129_g162712_i0	PRJNA615351	176812	159	1.016129	1.61564511	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	281	1.54e-71	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g162712	i0	98.734	64.3207547169811	158	2	99	0	2	159	53161	53004	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	10227	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
15898533	15898533	PRJNA615351_P_NODE_168053_length_167_cov_2.106061_g153953_i0	PRJNA615351	168053	167	2.106061	3.51712187	Fusobacterium polymorphum	76857	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2706067283\|gb\|CP077110.1\|	76857	g153953	i0	100	0.179640718562874	30	0	18	0	78	107	2236498	2236527	Fusobacterium polymorphum strain KCOM1278 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
18447628	18447628	PRJNA615351_P_NODE_150875_length_188_cov_6.483660_g136775_i0	PRJNA615351	150875	188	6.48366	12.1892808	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	342	8.539999999999999e-90	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g136775	i0	99.468	435.659574468085	188	1	100	0	1	188	53028	52841	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	81904	342	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
18447696	18447696	PRJNA615351_P_NODE_175575_length_160_cov_1.280000_g161475_i0	PRJNA615351	175575	160	1.28	2.048	Leptotrichia wadei	157687	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g161475	i0	100	29.84375	160	0	100	0	1	160	2247451	2247610	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	4775	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19722113	19722113	PRJNA615351_P_NODE_119216_length_252_cov_2.732719_g105116_i0	PRJNA615351	119216	252	2.732719	6.88645188	Fusobacterium mortiferum	850	Bacteria	Bacteria	158	4.71e-34	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g105116	i0	82.514	14.5119047619048	183	29	72	3	7	187	2678054	2677873	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	3657	158	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
19722593	19722593	PRJNA615351_P_NODE_92216_length_354_cov_1.711599_g78131_i0	PRJNA615351	92216	354	1.711599	6.05906046	Fusobacterium polymorphum	76857	Bacteria	Bacteria	126	1.95e-24	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g78131	i0	93.023	1.8728813559322	86	6	24	0	267	352	185313	185398	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	663	126	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
20997749	20997749	PRJNA615351_P_NODE_120237_length_249_cov_5.065421_g106137_i0	PRJNA615351	120237	249	5.065421	12.61289829	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	414	2.49e-111	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g106137	i0	97.154	459.923694779116	246	6	99	1	1	245	71147	71392	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	114521	414	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
22272626	22272626	PRJNA615351_P_NODE_109898_length_280_cov_4.379592_g95799_i0	PRJNA615351	109898	280	4.379592	12.2628576	Leptotrichia shahii	157691	Bacteria	Bacteria	368	2.26e-97	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g95799	i0	90.068	110.49642857142901	292	17	100	6	1	280	102569	102278	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	30939	368	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
22273148	22273148	PRJNA615351_P_NODE_97478_length_329_cov_1.496599_g83383_i0	PRJNA615351	97478	329	1.496599	4.92381071	Sneathia vaginalis	187101	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2831218648\|gb\|CP170997.1\|	187101	g83383	i0	100	0.0851063829787234	28	0	9	0	227	254	1194011	1193984	Sneathia vaginalis strain WGS1539 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
23548042	23548042	PRJNA615351_P_NODE_123999_length_240_cov_1.448780_g109899_i0	PRJNA615351	123999	240	1.44878	3.477072	Fusobacterium polymorphum	76857	Bacteria	Bacteria	60.2	1.29e-4	NTclustered	gi\|2706041172\|gb\|CP056018.1\|	76857	g109899	i0	97.143	0.729166666666667	35	1	15	0	193	227	1340569	1340603	Fusobacterium polymorphum strain SB006 chromosome, complete genome	blastn	175	60.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
23548064	23548064	PRJNA615351_P_NODE_131599_length_222_cov_3.288770_g117499_i0	PRJNA615351	131599	222	3.28877	7.3010694	uncultured Ilyobacter sp.	544433	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2814788377\|emb\|OY764057.2\|	544433	g117499	i0	100	0.126126126126126	28	0	13	0	139	166	1703779	1703752	MAG: uncultured Ilyobacter sp. isolate b6197fd5-c757-4c76-928f-f28f0df2880b genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Ilyobacter	uncultured Ilyobacter sp.

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