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

12 rows where analysis = "blastn", bioproject = "PRJNA1034994" 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
3994767	3994767	PRJNA1034994_P_NODE_3124_length_293_cov_0.900000_g3040_i0	PRJNA1034994	3124	293	0.9	2.637	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	531	2.86e-146	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g3040	i0	99.317	108.37542662116	293	2	100	0	1	293	51592	51884	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	31754	531	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
10371500	10371500	PRJNA1034994_P_NODE_6449_length_252_cov_2.648045_g6365_i0	PRJNA1034994	6449	252	2.648045	6.6730734	Leptotrichia wadei	157687	Bacteria	Bacteria	438	1.5e-118	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g6365	i0	98.016	287.40873015873	252	5	100	0	1	252	1756508	1756759	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	72427	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
12921924	12921924	PRJNA1034994_P_NODE_10431_length_237_cov_2.048780_g10347_i0	PRJNA1034994	10431	237	2.04878	4.8556086	Leptotrichia wadei	157687	Bacteria	Bacteria	427	3.03e-115	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g10347	i0	99.156	93.8776371308017	237	2	100	0	1	237	220391	220627	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	22249	427	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
12921935	12921935	PRJNA1034994_P_NODE_2031_length_358_cov_1.171930_g1947_i0	PRJNA1034994	2031	358	1.17193	4.1955094	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	601	2.6799999999999996e-167	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g1947	i0	96.927	300.567039106145	358	11	100	0	1	358	51814	52171	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	107603	601	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
12921951	12921951	PRJNA1034994_P_NODE_4071_length_280_cov_1.193237_g3987_i0	PRJNA1034994	4071	280	1.193237	3.3410636	Fusobacterium nucleatum	851	Bacteria	Bacteria	512	9.85e-141	NTclustered	gi\|2705032171\|gb\|CP084140.1\|	851	g3987	i0	99.643	66.6214285714286	280	1	100	0	1	280	429743	430022	Fusobacterium nucleatum strain KCOM3187 chromosome, complete genome	blastn	18654	512	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
14196851	14196851	PRJNA1034994_P_NODE_1812_length_377_cov_1.628289_g1728_i0	PRJNA1034994	1812	377	1.628289	6.13864953	Leptotrichia wadei	157687	Bacteria	Bacteria	662	0	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g1728	i0	98.919	355.151193633952	370	4	99	0	1	370	2369809	2369440	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	133892	662	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
20133919	20133919	PRJNA1034994_P_NODE_10416_length_237_cov_2.817073_g10332_i0	PRJNA1034994	10416	237	2.817073	6.67646301	Fusobacterium	848	Bacteria	Bacteria	438	1.4e-118	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g10332	i0	100	470.995780590717	237	0	100	0	1	237	106864	106628	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	111626	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
20133943	20133943	PRJNA1034994_P_NODE_2676_length_314_cov_2.112033_g2592_i0	PRJNA1034994	2676	314	2.112033	6.63178362	Leptotrichia	32067	Bacteria	Bacteria	503	6.75e-138	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g2592	i0	95.57	462.063694267516	316	11	99	3	2	314	71504	71189	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	145088	507	0.992110453648915	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
20569384	20569384	PRJNA1034994_P_NODE_2237_length_343_cov_1.051852_g2153_i0	PRJNA1034994	2237	343	1.051852	3.60785236	Fusobacterium hominis	2764326	Bacteria	Bacteria	582	9.3e-162	NTclustered	gi\|1897733338\|gb\|CP060637.1\|	2764326	g2153	i0	97.368	518.728862973761	342	9	99	0	2	343	782486	782827	Fusobacterium hominis strain NSJ-57 chromosome, complete genome	blastn	177924	582	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hominis
20569385	20569385	PRJNA1034994_P_NODE_2257_length_341_cov_2.623134_g2173_i0	PRJNA1034994	2257	341	2.623134	8.94488694	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	508	1.59e-139	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g2173	i0	93.567	292.181818181818	342	21	100	1	1	341	53155	52814	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	99634	508	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
23959880	23959880	PRJNA1034994_P_NODE_2639_length_317_cov_1.262295_g2555_i0	PRJNA1034994	2639	317	1.262295	4.00147515	Fusobacterium	848	Bacteria	Bacteria	586	6.579999999999998e-163	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g2555	i0	100	493.242902208202	317	0	100	0	1	317	106566	106250	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	156358	586	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
25233762	25233762	PRJNA1034994_P_NODE_1580_length_402_cov_2.422492_g1496_i0	PRJNA1034994	1580	402	2.422492	9.73841784	Leptotrichia	32067	Bacteria	Bacteria	654	0	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g1496	i0	96.02	429.405472636816	402	16	100	0	1	402	119195	119596	Leptotrichia buccalis DSM 1135, complete genome	blastn	172621	660	0.990909090909091	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis

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