metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJEB8827" and tax

17 rows where analysis = "blastn", bioproject = "PRJEB8827" 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
25530301	25530301	PRJEB8827h_S_NODE_1481_length_256_cov_221.447964_g1462_i0	PRJEB8827	1481	256	221.447964	566.90678784	Cetobacterium somerae	188913	Bacteria	Bacteria	368	2.03e-97	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g1462	i0	98.113	387.12109375	212	3	82	1	13	223	1318777	1318988	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	99103	368	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25617631	25617631	PRJEB8827e_S_NODE_5481_length_213_cov_2.634831_g5453_i0	PRJEB8827	5481	213	2.634831	5.61219003	Cetobacterium	180162	Bacteria	Bacteria	281	2.2e-71	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g5453	i0	91.667	4.7887323943662	204	16	96	1	10	213	81258	81056	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1020	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25665948	25665948	PRJEB8827f_S_NODE_2946_length_253_cov_203.683486_g2926_i0	PRJEB8827	2946	253	203.683486	515.31921958	Cetobacterium somerae	188913	Bacteria	Bacteria	370	5.58e-98	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g2926	i0	98.565	394.604743083004	209	3	83	0	15	223	1318780	1318988	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	99835	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25802509	25802509	PRJEB8827h_S_NODE_715_length_330_cov_9.325424_g696_i0	PRJEB8827	715	330	9.325424	30.7738992	Cetobacterium somerae	188913	Bacteria	Bacteria	544	4.1999999999999997e-150	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g696	i0	98.697	471.215151515151	307	3	93	1	24	330	420485	420180	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	155501	544	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25889592	25889592	PRJEB8827e_S_NODE_27363_length_170_cov_4.370370_g27335_i0	PRJEB8827	27363	170	4.37037	7.429629	Cetobacterium	180162	Bacteria	Bacteria	298	1.65e-76	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g27335	i0	98.235	499.970588235294	170	3	100	0	1	170	279697	279528	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	84995	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25889770	25889770	PRJEB8827h_S_NODE_11_length_942_cov_10.575524_g4_i1	PRJEB8827	11	942	10.575524	99.62143608	Cetobacterium	180162	Bacteria	Bacteria	1718	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g4	i1	99.575	525.364118895966	942	4	100	0	1	942	279603	278662	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	494893	1718	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26026062	26026062	PRJEB8827f_S_NODE_9068_length_184_cov_1.543624_g9048_i0	PRJEB8827	9068	184	1.543624	2.84026816	Cetobacterium	180162	Bacteria	Bacteria	318	1.3999999999999995e-82	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g9048	i0	97.826	497.880434782609	184	4	100	0	1	184	279530	279713	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	91610	318	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26074129	26074129	PRJEB8827f_S_NODE_10909_length_179_cov_4.888889_g10889_i0	PRJEB8827	10909	179	4.888889	8.75111131	Cetobacterium somerae	188913	Bacteria	Bacteria	298	1.76e-76	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g10889	i0	96.667	57.3072625698324	180	4	100	2	1	179	420195	420373	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	10258	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26074667	26074667	PRJEB8827h_S_NODE_31733_length_174_cov_8.589928_g31714_i0	PRJEB8827	31733	174	8.589928	14.94647472	Sneathia vaginalis	187101	Bacteria	Bacteria	231	1.75e-56	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g31714	i0	90.751	224.362068965517	173	16	99	0	1	173	160049	159877	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	39039	231	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
26162200	26162200	PRJEB8827g_S_NODE_1597_length_246_cov_115.199052_g1576_i0	PRJEB8827	1597	246	115.199052	283.38966792	Cetobacterium	180162	Bacteria	Bacteria	368	1.94e-97	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g1576	i0	98.565	404.430894308943	209	2	85	1	5	212	278074	277866	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	99490	368	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26210293	26210293	PRJEB8827e_S_NODE_43198_length_151_cov_1.301724_g43170_i0	PRJEB8827	43198	151	1.301724	1.96560324	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	185	1.1599999999999999e-42	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g43170	i0	89.333	22.4304635761589	150	13	98	3	4	151	397313	397165	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	3387	185	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
26298053	26298053	PRJEB8827h_S_NODE_6_length_1113_cov_12.735622_g4_i0	PRJEB8827	6	1113	12.735622	141.74747286	Cetobacterium	180162	Bacteria	Bacteria	1474	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g4	i0	90.812	510.643306379155	1121	76	99	23	6	1113	278497	279603	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	568346	1474	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26434084	26434084	PRJEB8827g_S_NODE_1791_length_235_cov_4.755000_g1770_i0	PRJEB8827	1791	235	4.755	11.17425	Cetobacterium	180162	Bacteria	Bacteria	353	5.16e-93	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g1770	i0	97.143	418.306382978723	210	4	89	2	23	231	277866	278074	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	98302	353	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26482121	26482121	PRJEB8827b_S_NODE_1768_length_249_cov_5.471963_g1716_i0	PRJEB8827	1768	249	5.471963	13.62518787	Cetobacterium somerae	188913	Bacteria	Bacteria	353	5.52e-93	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g1716	i0	97.143	397.024096385542	210	4	84	2	31	239	1318780	1318988	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	98859	353	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26482860	26482860	PRJEB8827g_S_NODE_1704_length_240_cov_7.687805_g1683_i0	PRJEB8827	1704	240	7.687805	18.450732	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g1683	i0	100	0.120833333333333	29	0	12	0	89	117	88098	88070	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
26569828	26569828	PRJEB8827e_S_NODE_144_length_777_cov_9.374663_g135_i0	PRJEB8827	144	777	9.374663	72.84113151	Cetobacterium	180162	Bacteria	Bacteria	1413	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g135	i0	99.485	519.786357786358	777	4	100	0	1	777	279437	278661	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	403874	1413	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26569977	26569977	PRJEB8827f_S_NODE_56_length_804_cov_9.314694_g48_i0	PRJEB8827	56	804	9.314694	74.89013976	Cetobacterium	180162	Bacteria	Bacteria	1458	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g48	i0	99.378	514.945273631841	804	5	100	0	1	804	278717	279520	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	414016	1458	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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