metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJEB6584" and tax

23 rows where analysis = "blastn", bioproject = "PRJEB6584" 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
10333349	10333349	PRJEB6584_P_NODE_509_length_227_cov_8.070707_g495_i0	PRJEB6584	509	227	8.070707	18.32050489	Cetobacterium somerae	188913	Bacteria	Bacteria	359	1.06e-94	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g495	i0	98.068	428.185022026432	207	3	91	1	1	206	1318782	1318988	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	97198	359	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25523761	25523761	PRJEB6584e_S_NODE_4257_length_152_cov_1.299145_g4242_i0	PRJEB6584	4257	152	1.299145	1.9747004	Fusobacterium gastrosuis	1755100	Bacteria	Bacteria	65.8	1.6e-6	NTclustered	gi\|1795735174\|emb\|LT607734.1\|	1755100	g4242	i0	97.368	0.25	38	1	25	0	2	39	53863	53900	Fusobacterium sp. P6 Po strain Fusobacterium gastrosuis sp. nov. CDW1, P6 Po genome assembly, chromosome: chr	blastn	38	65.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium gastrosuis
25615860	25615860	PRJEB6584i_S_NODE_1393_length_252_cov_77.866359_g1381_i0	PRJEB6584	1393	252	77.866359	196.22322468	Cetobacterium	180162	Bacteria	Bacteria	368	2e-97	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g1381	i0	98.565	394.801587301587	209	2	83	1	15	222	278074	277866	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	99490	368	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25659252	25659252	PRJEB6584a_S_NODE_2154_length_250_cov_348.716279_g2134_i0	PRJEB6584	2154	250	348.716279	871.7906975	Cetobacterium somerae	188913	Bacteria	Bacteria	368	1.98e-97	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g2134	i0	98.565	395.884	209	2	83	1	30	237	1318988	1318780	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	98971	368	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25659661	25659661	PRJEB6584d_S_NODE_7306_length_221_cov_10.354839_g7238_i0	PRJEB6584	7306	221	10.354839	22.88419419	Cetobacterium somerae	188913	Bacteria	Bacteria	374	3.68e-99	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g7238	i0	97.706	459.190045248869	218	3	98	2	6	221	1318771	1318988	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	101481	374	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25659815	25659815	PRJEB6584j_S_NODE_2170_length_248_cov_65.169014_g2141_i0	PRJEB6584	2170	248	65.169014	161.61915472	Cetobacterium somerae	188913	Bacteria	Bacteria	361	3.2799999999999995e-95	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g2141	i0	98.077	401.443548387097	208	3	83	1	23	229	1318987	1318780	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	99558	361	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25661189	25661189	PRJEB6584o_S_NODE_60282_length_162_cov_3.700787_g60174_i0	PRJEB6584	60282	162	3.700787	5.99527494	Cetobacterium somerae	188913	Bacteria	Bacteria	124	2.8199999999999994e-24	NTclustered	gi\|2201062203\|gb\|CP092525.1\|	188913	g60174	i0	93.902	0.882716049382716	82	5	88	0	62	143	4104	4023	Cetobacterium somerae strain CS2105-BJ plasmid unnamed6, complete sequence	blastn	143	124	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25752409	25752409	PRJEB6584o_S_NODE_2818_length_430_cov_10.040506_g2713_i0	PRJEB6584	2818	430	10.040506	43.1741758	Cetobacterium	180162	Bacteria	Bacteria	710	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g2713	i0	98.276	484.167441860465	406	6	94	1	25	430	420479	420075	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	208192	710	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25752547	25752547	PRJEB6584o_S_NODE_930_length_607_cov_19.968531_g872_i0	PRJEB6584	930	607	19.968531	121.20898317	Cetobacterium	180162	Bacteria	Bacteria	1081	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g872	i0	99.495	508.110378912685	594	3	98	0	14	607	279495	278902	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	308423	1081	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25795707	25795707	PRJEB6584e_S_NODE_1955_length_204_cov_7.650888_g1940_i0	PRJEB6584	1955	204	7.650888	15.60781152	Cetobacterium somerae	188913	Bacteria	Bacteria	359	9.36e-95	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g1940	i0	98.529	470.867647058824	204	2	100	1	1	204	1318786	1318988	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	96057	359	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25797455	25797455	PRJEB6584o_S_NODE_82603_length_150_cov_2.243478_g82495_i0	PRJEB6584	82603	150	2.243478	3.365217	Fusobacterium mortiferum ATCC 9817	469616	Bacteria	Bacteria	60.2	7.3e-5	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g82495	i0	88	0.333333333333333	50	6	33	0	101	150	1868988	1868939	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	50	60.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
25888015	25888015	PRJEB6584o_S_NODE_10299_length_272_cov_3.147679_g10191_i0	PRJEB6584	10299	272	3.147679	8.56168688	Cetobacterium	180162	Bacteria	Bacteria	442	1.2699999999999995e-119	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g10191	i0	99.587	449.3125	242	1	89	0	28	269	278665	278906	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	122213	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25888127	25888127	PRJEB6584o_S_NODE_25171_length_189_cov_2.714286_g25063_i0	PRJEB6584	25171	189	2.714286	5.13000054	Cetobacterium	180162	Bacteria	Bacteria	327	2.41e-85	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g25063	i0	97.884	504.238095238095	189	4	100	0	1	189	279498	279686	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	95301	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25931992	25931992	PRJEB6584f_S_NODE_1644_length_218_cov_6.972678_g1638_i0	PRJEB6584	1644	218	6.972678	15.20043804	Cetobacterium somerae	188913	Bacteria	Bacteria	342	1.02e-89	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g1638	i0	96.209	458.738532110092	211	4	96	4	10	218	1318780	1318988	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	100005	342	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26160460	26160460	PRJEB6584l_S_NODE_6829_length_237_cov_13.945545_g6677_i0	PRJEB6584	6829	237	13.945545	33.05094165	Cetobacterium	180162	Bacteria	Bacteria	350	6.74e-92	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g6677	i0	97.115	410.852320675105	208	4	87	2	1	207	278072	277866	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	97372	350	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26160665	26160665	PRJEB6584o_S_NODE_4589_length_370_cov_8.576119_g4481_i0	PRJEB6584	4589	370	8.576119	31.7316403	Cetobacterium	180162	Bacteria	Bacteria	614	3.579999999999999e-171	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g4481	i0	98.841	465.218918918919	345	3	94	1	25	369	420479	420136	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	172131	614	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26204258	26204258	PRJEB6584d_S_NODE_6974_length_225_cov_2.678947_g6906_i0	PRJEB6584	6974	225	2.678947	6.02763075	Haliovirga abyssi	2996794	Bacteria	Bacteria	172	1.4699999999999999e-38	NTclustered	gi\|2502752323\|dbj\|AP027059.1\|	2996794	g6906	i0	82.381	191.262222222222	210	25	92	8	11	218	253814	254013	Fusobacteria bacterium IC12 DNA, complete genome	blastn	43034	172	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Haliovirgaceae	Haliovirga	Haliovirga abyssi
26204415	26204415	PRJEB6584k_S_NODE_1438_length_239_cov_8.406863_g1417_i0	PRJEB6584	1438	239	8.406863	20.09240257	Cetobacterium somerae	188913	Bacteria	Bacteria	372	1.45e-98	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g1417	i0	98.578	416.175732217573	211	2	88	1	21	230	1318988	1318778	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	99466	372	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26206134	26206134	PRJEB6584p_S_NODE_60030_length_150_cov_1.591304_g59999_i0	PRJEB6584	60030	150	1.591304	2.386956	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	195	1.92e-45	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g59999	i0	90.066	246.733333333333	151	13	100	2	1	150	397106	397255	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	37010	195	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
26339952	26339952	PRJEB6584b_S_NODE_6447_length_172_cov_8.598540_g6429_i0	PRJEB6584	6447	172	8.59854	14.7894888	Leptotrichia wadei	157687	Bacteria	Bacteria	239	1.03e-58	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g6429	i0	96.552	72.0639534883721	145	4	94	1	29	172	220352	220208	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	12395	239	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
26340528	26340528	PRJEB6584n_S_NODE_375_length_233_cov_3.909091_g369_i0	PRJEB6584	375	233	3.909091	9.10818203	Cetobacterium somerae	188913	Bacteria	Bacteria	370	5.07e-98	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g369	i0	98.571	432.244635193133	210	2	90	1	17	225	1318988	1318779	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	100713	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26476146	26476146	PRJEB6584b_S_NODE_1608_length_253_cov_30.371560_g1590_i0	PRJEB6584	1608	253	30.37156	76.8400468	Cetobacterium somerae	188913	Bacteria	Bacteria	446	9.01e-121	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g1590	i0	100	432.328063241107	241	0	95	0	13	253	1318988	1318748	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	109379	446	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26476371	26476371	PRJEB6584f_S_NODE_3192_length_184_cov_2.261745_g3186_i0	PRJEB6584	3192	184	2.261745	4.1616108	Haliovirga abyssi	2996794	Bacteria	Bacteria	76.8	9.31e-10	NTclustered	gi\|2502752323\|dbj\|AP027059.1\|	2996794	g3186	i0	92.593	57.0652173913044	54	3	29	1	1	54	254341	254289	Fusobacteria bacterium IC12 DNA, complete genome	blastn	10500	76.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Haliovirgaceae	Haliovirga	Haliovirga abyssi

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