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

14 rows where analysis = "blastn", bioproject = "PRJNA757618" 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
3283812	3283812	PRJNA757618_P_NODE_27983_length_252_cov_0.871508_g26931_i0	PRJNA757618	27983	252	0.871508	2.19620016	Leptotrichia mesophila	3239303	Bacteria	Bacteria	433	6.98e-117	NTclustered	gi\|2785242249\|gb\|CP165646.1\|	3239303	g26931	i0	97.628	7.17063492063492	253	5	100	1	1	252	2289433	2289685	Leptotrichia sp. HSP-342 chromosome, complete genome	blastn	1807	433	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia mesophila
4561171	4561171	PRJNA757618_P_NODE_44984_length_243_cov_0.917647_g43932_i0	PRJNA757618	44984	243	0.917647	2.22988221	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g43932	i0	100	8.00411522633745	243	0	100	0	1	243	581369	581611	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	1945	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
8385920	8385920	PRJNA757618_P_NODE_37447_length_247_cov_0.896552_g36395_i0	PRJNA757618	37447	247	0.896552	2.21448344	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g36395	i0	99.19	37.412955465587	247	2	100	0	1	247	1248488	1248242	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	9241	446	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
10131258	10131258	PRJNA757618_P_NODE_6188_length_493_cov_2.111905_g5137_i0	PRJNA757618	6188	493	2.111905	10.41169165	Fusobacterium	848	Bacteria	Bacteria	881	0	NTclustered	gi\|2445153921\|gb\|CP117797.1\|	851	g5137	i0	98.984	490.095334685598	492	5	99	0	2	493	113870	113379	Fusobacterium nucleatum strain FNA chromosome, complete genome	blastn	241617	881	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
10936742	10936742	PRJNA757618_P_NODE_40189_length_246_cov_0.884393_g39137_i0	PRJNA757618	40189	246	0.884393	2.17560678	Leptotrichia wadei	157687	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g39137	i0	100	185.630081300813	246	0	100	0	1	246	2012422	2012667	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	45665	455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
12682312	12682312	PRJNA757618_P_NODE_7950_length_400_cov_2.587156_g6898_i0	PRJNA757618	7950	400	2.587156	10.348624	Leptotrichia	32067	Bacteria	Bacteria	630	3.869999999999999e-176	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g6898	i0	99.709	396.02	344	1	100	0	57	400	198609	198266	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	158408	630	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
13956447	13956447	PRJNA757618_P_NODE_28651_length_252_cov_0.865922_g27599_i0	PRJNA757618	28651	252	0.865922	2.18212344	Fusobacterium	848	Bacteria	Bacteria	405	1.52e-108	NTclustered	gi\|2706459429\|gb\|CP084073.1\|	76859	g27599	i0	95.635	99.9920634920635	252	11	100	0	1	252	2087	1836	Fusobacterium animalis strain SB056 chromosome, complete genome	blastn	25198	405	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
19054142	19054142	PRJNA757618_P_NODE_20275_length_275_cov_1.757426_g19223_i0	PRJNA757618	20275	275	1.757426	4.8329215	Fusobacterium	848	Bacteria	Bacteria	507	4.49e-139	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g19223	i0	100	497.189090909091	274	0	99	0	2	275	93900	93627	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	136727	507	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
19859473	19859473	PRJNA757618_P_NODE_25356_length_257_cov_1.146739_g24304_i0	PRJNA757618	25356	257	1.146739	2.94711923	Leptotrichia wadei	157687	Bacteria	Bacteria	464	2.5299999999999998e-126	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g24304	i0	99.222	170.470817120623	257	2	100	0	1	257	221631	221375	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	43811	464	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19859800	19859800	PRJNA757618_P_NODE_48816_length_238_cov_2.139394_g47764_i0	PRJNA757618	48816	238	2.139394	5.09175772	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g47764	i0	100	225.781512605042	238	0	100	0	1	238	196919	196682	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	53736	440	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
21135017	21135017	PRJNA757618_P_NODE_27077_length_253_cov_0.866667_g26025_i0	PRJNA757618	27077	253	0.866667	2.19266751	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g26025	i0	99.605	3	253	1	100	0	1	253	937140	937392	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	759	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
23685301	23685301	PRJNA757618_P_NODE_16919_length_290_cov_13.285714_g15867_i0	PRJNA757618	16919	290	13.285714	38.5285706	Cetobacterium somerae	188913	Bacteria	Bacteria	520	6.119999999999998e-143	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g15867	i0	98.966	437.355172413793	290	3	100	0	1	290	48886	49175	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	126833	520	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24959145	24959145	PRJNA757618_P_NODE_34080_length_249_cov_0.880682_g33028_i0	PRJNA757618	34080	249	0.880682	2.19289818	Leptotrichia wadei	157687	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g33028	i0	98.394	19.6787148594378	249	4	100	0	1	249	1964919	1964671	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	4900	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
25429192	25429192	PRJNA757618_P_NODE_41680_length_245_cov_0.901163_g40628_i0	PRJNA757618	41680	245	0.901163	2.20784935	Fusobacterium	848	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2706060613\|gb\|CP077190.1\|	76859	g40628	i0	100	99.7918367346939	245	0	100	0	1	245	2226138	2226382	Fusobacterium animalis strain SB026 chromosome, complete genome	blastn	24449	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis

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