metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA473201" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA473201" 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
444209	444209	PRJNA473201_P_NODE_62041_length_261_cov_0.984043_g61299_i0	PRJNA473201	62041	261	0.984043	2.56835223	Cetobacterium somerae	188913	Bacteria	Bacteria	204	6.209999999999999e-48	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g61299	i0	87.293	0.693486590038314	181	20	68	3	84	261	346925	346745	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	181	204	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1095265	1095265	PRJNA473201_P_NODE_73081_length_247_cov_1.327586_g72339_i0	PRJNA473201	73081	247	1.327586	3.27913742	Cetobacterium	180162	Bacteria	Bacteria	351	1.97e-92	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g72339	i0	92.339	19.5263157894737	248	17	100	2	1	247	1903187	1902941	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4823	351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2994400	2994400	PRJNA473201_P_NODE_35183_length_335_cov_1.469466_g34441_i0	PRJNA473201	35183	335	1.469466	4.9227111	Cetobacterium somerae	188913	Bacteria	Bacteria	481	3.399999999999999e-131	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g34441	i0	92.537	96.4358208955224	335	25	100	0	1	335	383971	384305	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	32306	481	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3645252	3645252	PRJNA473201_P_NODE_11183_length_604_cov_19.273070_g10448_i0	PRJNA473201	11183	604	19.27307	116.4093428	Cetobacterium	180162	Bacteria	Bacteria	837	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g10448	i0	91.626	71.7566225165563	609	45	100	6	1	604	67070	67677	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	43341	837	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4271610	4271610	PRJNA473201_P_NODE_82004_length_243_cov_0.905882_g81262_i0	PRJNA473201	82004	243	0.905882	2.20129326	Cetobacterium somerae	188913	Bacteria	Bacteria	283	7.14e-72	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g81262	i0	87.654	4	243	30	100	0	1	243	996760	996518	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	972	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6198484	6198484	PRJNA473201_P_NODE_79665_length_244_cov_0.900585_g78923_i0	PRJNA473201	79665	244	0.900585	2.1974274	Cetobacterium	180162	Bacteria	Bacteria	302	1.98e-77	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g78923	i0	88.98	4.97131147540984	245	25	100	2	1	244	167827	167584	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1213	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15123195	15123195	PRJNA473201_P_NODE_78372_length_245_cov_0.889535_g77630_i0	PRJNA473201	78372	245	0.889535	2.17936075	Cetobacterium	180162	Bacteria	Bacteria	379	8.929999999999999e-101	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g77630	i0	95.122	150.722448979592	246	2	100	3	1	245	1815192	1814956	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	36927	379	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16397671	16397671	PRJNA473201_P_NODE_59633_length_267_cov_1.577320_g58891_i0	PRJNA473201	59633	267	1.57732	4.2114444	Cetobacterium	180162	Bacteria	Bacteria	333	7.789999999999999e-87	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g58891	i0	89.179	5.31835205992509	268	27	100	2	1	267	670709	670443	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1420	333	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17672993	17672993	PRJNA473201_P_NODE_81814_length_243_cov_0.905882_g81072_i0	PRJNA473201	81814	243	0.905882	2.20129326	Cetobacterium	180162	Bacteria	Bacteria	228	3.389999999999999e-55	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g81072	i0	96.377	2.25514403292181	138	5	57	0	106	243	36747	36884	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	548	228	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18294972	18294972	PRJNA473201_P_NODE_15315_length_509_cov_10.816514_g14574_i0	PRJNA473201	15315	509	10.816514	55.05605626	Cetobacterium somerae	188913	Bacteria	Bacteria	894	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g14574	i0	98.428	521.803536345776	509	7	100	1	1	509	1318462	1318969	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	265598	894	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18946456	18946456	PRJNA473201_P_NODE_49875_length_292_cov_1.406393_g49133_i0	PRJNA473201	49875	292	1.406393	4.10666756	Cetobacterium	180162	Bacteria	Bacteria	357	5.12e-94	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g49133	i0	89.437	9.40068493150685	284	28	97	2	9	292	1368853	1369134	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2745	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19569763	19569763	PRJNA473201_P_NODE_53256_length_284_cov_1.094787_g52514_i0	PRJNA473201	53256	284	1.094787	3.10919508	Cetobacterium somerae	188913	Bacteria	Bacteria	459	1.3199999999999998e-124	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g52514	i0	95.789	14.7535211267606	285	11	100	1	1	284	384721	385005	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	4190	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20845505	20845505	PRJNA473201_P_NODE_43277_length_309_cov_1.305085_g42535_i0	PRJNA473201	43277	309	1.305085	4.03271265	Cetobacterium somerae	188913	Bacteria	Bacteria	230	1.2399999999999998e-55	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g42535	i0	80.519	4.98381877022654	308	52	99	3	3	309	1161291	1161591	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1540	230	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21496455	21496455	PRJNA473201_P_NODE_31697_length_351_cov_4.665468_g30955_i0	PRJNA473201	31697	351	4.665468	16.37579268	Cetobacterium	180162	Bacteria	Bacteria	532	9.719999999999999e-147	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g30955	i0	94.286	91.8404558404558	350	17	99	3	1	349	479374	479027	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	32236	532	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22771161	22771161	PRJNA473201_P_NODE_11218_length_603_cov_16.322642_g10483_i0	PRJNA473201	11218	603	16.322642	98.42553126	Cetobacterium	180162	Bacteria	Bacteria	765	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g10483	i0	90.783	79.0762852404643	575	50	95	3	1	575	1561234	1561805	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	47683	765	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22772052	22772052	PRJNA473201_P_NODE_55598_length_278_cov_1.126829_g54856_i0	PRJNA473201	55598	278	1.126829	3.13258462	Cetobacterium	180162	Bacteria	Bacteria	464	2.77e-126	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g54856	i0	96.774	19.0179856115108	279	8	100	1	1	278	480649	480371	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5287	464	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24046912	24046912	PRJNA473201_P_NODE_52499_length_286_cov_1.079812_g51757_i0	PRJNA473201	52499	286	1.079812	3.08826232	Cetobacterium	180162	Bacteria	Bacteria	390	4.929999999999999e-104	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g51757	i0	91.259	99.8006993006993	286	25	100	0	1	286	346087	346372	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	28543	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24670036	24670036	PRJNA473201_P_NODE_45020_length_304_cov_1.333333_g44278_i0	PRJNA473201	45020	304	1.333333	4.05333232	Cetobacterium somerae	188913	Bacteria	Bacteria	368	2.48e-97	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g44278	i0	88.525	70.8717105263158	305	33	100	2	1	304	1086662	1086965	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	21545	368	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25320990	25320990	PRJNA473201_P_NODE_37540_length_326_cov_0.992095_g36798_i0	PRJNA473201	37540	326	0.992095	3.2342297	Cetobacterium	180162	Bacteria	Bacteria	536	6.939999999999997e-148	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g36798	i0	96.341	10.1748466257669	328	8	100	3	1	326	1523311	1523636	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	3317	536	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);;