metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA459724" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA459724" 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
443055	443055	PRJNA459724_S_NODE_1301_length_188_cov_6.241830_g1298_i0	PRJNA459724	1301	188	6.24183	11.7346404	Fusobacterium animalis	76859	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|2706051909\|gb\|CP077183.1\|	76859	g1298	i0	100	1	188	0	100	0	1	188	965257	965070	Fusobacterium animalis strain SB031 chromosome, complete genome	blastn	188	348	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
2369346	2369346	PRJNA459724_P_NODE_2022_length_378_cov_17.000000_g1637_i0	PRJNA459724	2022	378	17	64.26	Fusobacterium	848	Bacteria	Bacteria	593	4.769999999999998e-165	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g1637	i0	97.151	468.055555555556	351	10	93	0	1	351	338055	337705	Fusobacterium varium strain SB069 chromosome	blastn	176925	593	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
3645065	3645065	PRJNA459724_P_NODE_4243_length_203_cov_31.074713_g3851_i0	PRJNA459724	4243	203	31.074713	63.08166739	Fusobacterium	848	Bacteria	Bacteria	307	3.42e-79	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g3851	i0	96.257	440.916256157635	187	7	92	0	1	187	155602	155788	Fusobacterium varium strain SB069 chromosome	blastn	89506	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
6820694	6820694	PRJNA459724_P_NODE_1146_length_548_cov_33.109827_g848_i0	PRJNA459724	1146	548	33.109827	181.44185196	Fusobacterium perfoetens	852	Bacteria	Bacteria	811	0	NTclustered	gi\|13447141\|gb\|AF342857.1\|	852	g848	i0	97.095	527.215328467153	482	12	88	2	69	548	745	264	Fusobacterium perfoetens strain ATCC 29250 16S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	288914	811	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
6820702	6820702	PRJNA459724_P_NODE_3646_length_233_cov_31.480392_g3254_i0	PRJNA459724	3646	233	31.480392	73.34931336	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	274	4.09e-69	NTclustered	gi\|2892346784\|dbj\|AP035781.1\|	2053555	g3254	i0	88.362	465.716738197425	232	22	98	4	1	229	4668	4897	Fusobacteriaceae bacterium 9N8 DNA, complete genome	blastn	108512	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
7471936	7471936	PRJNA459724_P_NODE_1786_length_415_cov_29.702073_g1415_i0	PRJNA459724	1786	415	29.702073	123.26360295	Fusobacterium	848	Bacteria	Bacteria	660	0	NTclustered	gi\|2705015041\|gb\|CP084068.1\|	856	g1415	i0	95.422	523.151807228916	415	18	100	1	1	415	232151	232564	Fusobacterium varium strain SB064 chromosome, complete genome	blastn	217108	660	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
10646904	10646904	PRJNA459724_P_NODE_529_length_811_cov_24.865729_g346_i0	PRJNA459724	529	811	24.865729	201.66106219	Fusobacterium hominis	2764326	Bacteria	Bacteria	1081	0	NTclustered	gi\|1897733338\|gb\|CP060637.1\|	2764326	g346	i0	90.786	538.664611590629	814	67	100	8	1	811	782068	782876	Fusobacterium hominis strain NSJ-57 chromosome, complete genome	blastn	436857	1081	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hominis
12572846	12572846	PRJNA459724_P_NODE_1970_length_386_cov_22.288515_g1587_i0	PRJNA459724	1970	386	22.288515	86.0336679	Cetobacterium	180162	Bacteria	Bacteria	549	1.0699999999999996e-151	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g1587	i0	92.448	513.370466321243	384	29	99	0	1	384	278605	278988	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	198161	549	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14471699	14471699	PRJNA459724_P_NODE_3892_length_220_cov_13.706806_g3500_i0	PRJNA459724	3892	220	13.706806	30.1549732	Fusobacterium mortiferum	850	Bacteria	Bacteria	407	3.61e-109	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g3500	i0	100	517.759090909091	220	0	100	0	1	220	103893	104112	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	113907	407	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
16396523	16396523	PRJNA459724_P_NODE_3793_length_225_cov_55.698980_g3401_i0	PRJNA459724	3793	225	55.69898	125.322705	Fusobacterium	848	Bacteria	Bacteria	359	1.0499999999999999e-94	NTclustered	gi\|645320556\|ref\|NR_117734.1\|	850	g3401	i0	95.556	127.004444444444	225	9	99	1	2	225	1463	1239	Fusobacterium mortiferum strain DSM 19809 16S ribosomal RNA, partial sequence	blastn	28576	359	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
17020384	17020384	PRJNA459724_P_NODE_1234_length_525_cov_11.461694_g924_i0	PRJNA459724	1234	525	11.461694	60.1738935	Fusobacterium mortiferum	850	Bacteria	Bacteria	931	0	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g924	i0	98.667	498.628571428571	525	7	100	0	1	525	105819	105295	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	261780	931	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
18945479	18945479	PRJNA459724_P_NODE_3995_length_215_cov_9.763441_g3603_i0	PRJNA459724	3995	215	9.763441	20.99139815	Fusobacterium	848	Bacteria	Bacteria	270	4.81e-68	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g3603	i0	97.468	460.693023255814	158	4	100	0	58	215	91794	91637	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	99049	270	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
19568809	19568809	PRJNA459724_S_NODE_176_length_288_cov_14447.624506_g173_i0	PRJNA459724	176	288	14447.624506	41609.15857728	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	268	2.43e-67	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g173	i0	89.904	29.8263888888889	208	21	72	0	81	288	137592	137385	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	8590	268	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
20844695	20844695	PRJNA459724_P_NODE_1137_length_549_cov_30.275000_g840_i0	PRJNA459724	1137	549	30.275	166.20975	Fusobacterium perfoetens	852	Bacteria	Bacteria	728	0	NTclustered	gi\|13447141\|gb\|AF342857.1\|	852	g840	i0	93.996	525.897996357013	483	26	88	3	1	481	264	745	Fusobacterium perfoetens strain ATCC 29250 16S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	288718	728	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens

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