metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA814235" 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
816964	816964	PRJNA814235_P_NODE_191141_length_151_cov_2.921053_g189746_i0	PRJNA814235	191141	151	2.921053	4.41079003	Leptotrichia wadei	157687	Bacteria	Bacteria	145	1.98e-30	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g189746	i0	100	4.56953642384106	78	0	100	0	1	78	1701750	1701827	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	690	145	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
3367898	3367898	PRJNA814235_P_NODE_193663_length_151_cov_2.649123_g192268_i0	PRJNA814235	193663	151	2.649123	4.00017573	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	139	9.19e-29	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g192268	i0	97.531	19.1523178807947	81	2	100	0	1	81	2170209	2170289	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	2892	139	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
3369459	3369459	PRJNA814235_P_NODE_80403_length_212_cov_1.925714_g79008_i0	PRJNA814235	80403	212	1.925714	4.08251368	Sneathia sanguinegens	40543	Bacteria	Bacteria	392	9.67e-105	NTclustered	gi\|2769805188\|gb\|CP160095.1\|	40543	g79008	i0	100	402.561320754717	212	0	100	0	1	212	3243	3032	Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome	blastn	85343	392	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens
3778523	3778523	PRJNA814235_P_NODE_201983_length_150_cov_2.070796_g200588_i0	PRJNA814235	201983	150	2.070796	3.106194	Fusobacterium	848	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|2705003210\|gb\|CP084117.1\|	851	g200588	i0	100	100	150	0	100	0	1	150	624937	625086	Fusobacterium nucleatum strain KCOM3486 chromosome, complete genome	blastn	15000	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
3778667	3778667	PRJNA814235_P_NODE_29463_length_352_cov_5.441270_g28080_i0	PRJNA814235	29463	352	5.44127	19.1532704	Fusobacterium	848	Bacteria	Bacteria	575	1.5999999999999995e-159	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g28080	i0	96.067	487.985795454545	356	3	100	2	1	352	107952	107604	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	171771	575	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
7604608	7604608	PRJNA814235_P_NODE_191446_length_151_cov_2.894737_g190051_i0	PRJNA814235	191446	151	2.894737	4.37105287	Fusobacterium	848	Bacteria	Bacteria	141	2.56e-29	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g190051	i0	100	78.0927152317881	76	0	100	0	1	76	1975349	1975424	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	11792	141	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
8471705	8471705	PRJNA814235_P_NODE_89187_length_203_cov_3.626506_g87792_i0	PRJNA814235	89187	203	3.626506	7.36180718	Leptotrichia wadei	157687	Bacteria	Bacteria	141	3.67e-29	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g87792	i0	100	2.98522167487685	76	0	74	0	128	203	2194874	2194799	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	606	141	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
11019091	11019091	PRJNA814235_P_NODE_113529_length_203_cov_1.975904_g112134_i0	PRJNA814235	113529	203	1.975904	4.01108512	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	135	1.71e-27	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g112134	i0	98.684	40.0394088669951	76	1	75	0	128	203	750403	750328	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	8128	135	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
12706036	12706036	PRJNA814235_P_NODE_182750_length_151_cov_5.368421_g181355_i0	PRJNA814235	182750	151	5.368421	8.10631571	Fusobacterium	848	Bacteria	Bacteria	135	1.19e-27	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g181355	i0	98.684	18.5562913907285	76	1	100	0	1	76	2285801	2285726	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	2802	135	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
13979306	13979306	PRJNA814235_P_NODE_102091_length_203_cov_2.349398_g100696_i0	PRJNA814235	102091	203	2.349398	4.76927794	Leptotrichia	32067	Bacteria	Bacteria	139	1.3199999999999999e-28	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g100696	i0	100	3.67487684729064	75	0	37	0	1	75	2187470	2187396	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	746	139	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
14843610	14843610	PRJNA814235_P_NODE_124812_length_201_cov_2.207317_g123417_i0	PRJNA814235	124812	201	2.207317	4.43670717	Leptotrichia rugosa	3239302	Bacteria	Bacteria	141	3.63e-29	NTclustered	gi\|2785246835\|gb\|CP165644.1\|	3239302	g123417	i0	100	2.2089552238806	76	0	74	0	126	201	1914458	1914533	Leptotrichia sp. HSP-334 chromosome, complete genome	blastn	444	141	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia rugosa
16118709	16118709	PRJNA814235_P_NODE_153573_length_171_cov_3.067164_g152178_i0	PRJNA814235	153573	171	3.067164	5.24485044	Fusobacterium vincentii	155615	Bacteria	Bacteria	311	2.14e-80	NTclustered	gi\|2706043502\|gb\|CP077176.1\|	155615	g152178	i0	99.415	471	171	1	100	0	1	171	350141	350311	Fusobacterium vincentii strain SB037 chromosome, complete genome	blastn	80541	311	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium vincentii
16119477	16119477	PRJNA814235_P_NODE_186353_length_151_cov_3.605263_g184958_i0	PRJNA814235	186353	151	3.605263	5.44394713	Sneathia vaginalis	187101	Bacteria	Bacteria	213	5.34e-51	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g184958	i0	91.411	3.23841059602649	163	2	100	2	1	151	561393	561555	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	489	213	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
17396018	17396018	PRJNA814235_P_NODE_39414_length_304_cov_3.071161_g38023_i0	PRJNA814235	39414	304	3.071161	9.33632944	Fusobacterium mortiferum	850	Bacteria	Bacteria	529	1.0699999999999996e-145	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g38023	i0	98.026	413.595394736842	304	6	100	0	1	304	105483	105786	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	125733	529	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
17804539	17804539	PRJNA814235_P_NODE_40434_length_300_cov_3.505703_g39043_i0	PRJNA814235	40434	300	3.505703	10.517109	Fusobacterium	848	Bacteria	Bacteria	536	6.319999999999997e-148	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g39043	i0	99	513.01	300	2	100	1	1	300	3422599	3422301	Fusobacterium varium strain SB069 chromosome	blastn	153903	536	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
18668397	18668397	PRJNA814235_P_NODE_191155_length_151_cov_2.921053_g189760_i0	PRJNA814235	191155	151	2.921053	4.41079003	Fusobacterium polymorphum	76857	Bacteria	Bacteria	135	1.19e-27	NTclustered	gi\|2706501616\|gb\|CP084155.1\|	76857	g189760	i0	98.684	0.503311258278146	76	1	50	0	1	76	11929	12004	Fusobacterium polymorphum strain KCOM2517 plasmid pKCOM2517, complete sequence	blastn	76	135	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
19078491	19078491	PRJNA814235_P_NODE_30675_length_345_cov_5.935065_g29291_i0	PRJNA814235	30675	345	5.935065	20.47597425	Fusobacterium	848	Bacteria	Bacteria	531	3.439999999999999e-146	NTclustered	gi\|2705040003\|gb\|CP084146.1\|	851	g29291	i0	94.302	488.805797101449	351	12	100	5	1	345	601985	602333	Fusobacterium nucleatum strain KCOM2939 chromosome, complete genome	blastn	168638	531	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
21217200	21217200	PRJNA814235_P_NODE_101697_length_203_cov_2.367470_g100302_i0	PRJNA814235	101697	203	2.36747	4.8059641	Fusobacterium polymorphum	76857	Bacteria	Bacteria	141	3.67e-29	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g100302	i0	100	17.7832512315271	76	0	75	0	128	203	331279	331204	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	3610	141	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
25043203	25043203	PRJNA814235_P_NODE_184400_length_151_cov_4.140351_g183005_i0	PRJNA814235	184400	151	4.140351	6.25193001	Fusobacterium polymorphum	76857	Bacteria	Bacteria	215	1.49e-51	NTclustered	gi\|2706056059\|gb\|CP077188.1\|	76857	g183005	i0	91.515	109.192052980132	165	0	100	1	1	151	2089444	2089280	Fusobacterium polymorphum strain SB028 chromosome, complete genome	blastn	16488	215	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
25043458	25043458	PRJNA814235_P_NODE_199100_length_150_cov_3.247788_g197705_i0	PRJNA814235	199100	150	3.247788	4.871682	Leptotrichia buccalis	40542	Bacteria	Bacteria	84.2	4.33e-12	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g197705	i0	86.667	0.5	75	10	50	0	1	75	565109	565035	Leptotrichia buccalis DSM 1135, complete genome	blastn	75	84.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis

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