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

20 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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
181325	181325	PRJNA1067370_S_NODE_661_length_514_cov_8.619048_g635_i0	PRJNA1067370	661	514	8.619048	44.30190672	Leptotrichia alba	3239304	Bacteria	Bacteria	950	0	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g635	i0	100	415.599221789883	514	0	100	0	1	514	88873	88360	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	213618	950	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
1013385	1013385	PRJNA1067370_S_NODE_421_length_602_cov_1.262760_g395_i0	PRJNA1067370	421	602	1.26276	7.6018152	Fusobacterium	848	Bacteria	Bacteria	1059	0	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g395	i0	99.655	458.855481727575	579	2	96	0	1	579	594	16	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	276231	1064	0.995300751879699	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
3563885	3563885	PRJNA1067370_P_NODE_6283_length_708_cov_1.807874_g5777_i0	PRJNA1067370	6283	708	1.807874	12.79974792	Fusobacterium	848	Bacteria	Bacteria	1253	0	NTclustered	gi\|2707716151\|gb\|CP077166.1\|	76857	g5777	i0	98.588	477.314971751412	708	10	100	0	1	708	294787	294080	Fusobacterium polymorphum strain SB047 chromosome	blastn	337939	1253	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
4841227	4841227	PRJNA1067370_P_NODE_17804_length_442_cov_1.417344_g17256_i0	PRJNA1067370	17804	442	1.417344	6.26466048	Leptotrichia	32067	Bacteria	Bacteria	795	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g17256	i0	99.095	187.509049773756	442	4	100	0	1	442	458	17	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	82879	795	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
6116348	6116348	PRJNA1067370_P_NODE_17505_length_445_cov_2.459677_g16957_i0	PRJNA1067370	17505	445	2.459677	10.94556265	Fusobacterium	848	Bacteria	Bacteria	817	0	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g16957	i0	99.775	434.101123595506	445	1	100	0	1	445	25	469	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	193175	817	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
6558958	6558958	PRJNA1067370_P_NODE_70506_length_264_cov_1.157068_g69957_i0	PRJNA1067370	70506	264	1.157068	3.05465952	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	483	7.219999999999998e-132	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g69957	i0	99.621	509.181818181818	264	1	100	0	1	264	71231	71494	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	134424	483	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
6559007	6559007	PRJNA1067370_P_NODE_78886_length_251_cov_1.926966_g78337_i0	PRJNA1067370	78886	251	1.926966	4.83668466	Fusobacterium hwasookii	1583098	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2078812864\|gb\|CP071092.1\|	1583098	g78337	i0	96.875	0.239043824701195	32	1	13	0	23	54	516053	516022	Fusobacterium hwasookii strain THCT14E2 chromosome, complete genome	blastn	60	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
8666469	8666469	PRJNA1067370_P_NODE_52407_length_291_cov_1.899083_g51858_i0	PRJNA1067370	52407	291	1.899083	5.52633153	Streptobacillus	34104	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1356701568\|gb\|CP027400.1\|	34105	g51858	i0	100	0.288659793814433	28	0	10	0	177	204	1008885	1008912	Streptobacillus moniliformis strain FDAARGOS_310 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
11216700	11216700	PRJNA1067370_P_NODE_6389_length_703_cov_1.834921_g5881_i0	PRJNA1067370	6389	703	1.834921	12.89949463	Cetobacterium	180162	Bacteria	Bacteria	1221	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g5881	i0	98.011	508.576102418208	704	13	100	1	1	703	278695	279398	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	357529	1221	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11659291	11659291	PRJNA1067370_P_NODE_19030_length_429_cov_1.514045_g18482_i0	PRJNA1067370	19030	429	1.514045	6.49525305	Fusobacterium varium	856	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|2318938525\|gb\|CP107203.1\|	856	g18482	i0	100	0.0652680652680653	28	0	7	0	398	425	1619986	1619959	MAG: Fusobacterium varium isolate KR001_HAM_0062 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
11659638	11659638	PRJNA1067370_P_NODE_66750_length_269_cov_3.459184_g66201_i0	PRJNA1067370	66750	269	3.459184	9.30520496	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	468	2.06e-127	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g66201	i0	98.134	392.568773234201	268	5	99	0	2	269	52842	53109	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	105601	468	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14209776	14209776	PRJNA1067370_P_NODE_74472_length_258_cov_1.291892_g73923_i0	PRJNA1067370	74472	258	1.291892	3.33308136	Leptotrichia alba	3239304	Bacteria	Bacteria	460	3.29e-125	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g73923	i0	98.837	206.306201550388	258	3	100	0	1	258	88541	88284	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	53227	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
16757493	16757493	PRJNA1067370_P_NODE_110634_length_242_cov_0.911243_g110085_i0	PRJNA1067370	110634	242	0.911243	2.20520806	Cetobacterium somerae	188913	Bacteria	Bacteria	283	7.1e-72	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g110085	i0	88.889	4.83057851239669	234	20	95	6	11	241	271028	270798	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1169	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16758204	16758204	PRJNA1067370_S_NODE_34_length_1303_cov_5.180488_g29_i0	PRJNA1067370	34	1303	5.180488	67.50175864	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	2362	0	NTclustered	gi\|1276712381\|gb\|CP024701.1\|	2663009	g29	i0	99.386	476.28626247122	1303	8	100	0	1	1303	622394	621092	Fusobacterium pseudoperiodonticum strain KCOM 1277 chromosome, complete genome	blastn	620601	2362	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
20139681	20139681	PRJNA1067370_P_NODE_35796_length_333_cov_0.923077_g35248_i0	PRJNA1067370	35796	333	0.923077	3.07384641	Leptotrichia	32067	Bacteria	Bacteria	616	8.87e-172	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g35248	i0	100	475.642642642643	333	0	100	0	1	333	2356	2024	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	158389	616	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
20582199	20582199	PRJNA1067370_P_NODE_7637_length_649_cov_1.805556_g7112_i0	PRJNA1067370	7637	649	1.805556	11.71805844	Leptotrichia wadei	157687	Bacteria	Bacteria	1138	0	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g7112	i0	98.305	426.941448382126	649	11	100	0	1	649	1779564	1778916	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	277085	1138	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
20582406	20582406	PRJNA1067370_S_NODE_5617_length_251_cov_0.865169_g5591_i0	PRJNA1067370	5617	251	0.865169	2.17157419	Leptotrichia alba	3239304	Bacteria	Bacteria	407	4.2099999999999995e-109	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g5591	i0	100	13.1673306772908	220	0	88	0	32	251	580885	581104	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	3305	407	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
20582408	20582408	PRJNA1067370_S_NODE_97_length_976_cov_20.578073_g86_i0	PRJNA1067370	97	976	20.578073	200.84199248	Leptotrichia alba	3239304	Bacteria	Bacteria	1694	0	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g86	i0	98.843	468.799180327869	951	9	97	2	1	951	2181768	2182716	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	457548	1694	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
21857825	21857825	PRJNA1067370_P_NODE_65258_length_272_cov_1.160804_g64709_i0	PRJNA1067370	65258	272	1.160804	3.15738688	Leptotrichia wadei	157687	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g64709	i0	100	0.102941176470588	28	0	10	0	217	244	1962682	1962709	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
21858076	21858076	PRJNA1067370_S_NODE_2778_length_323_cov_2.004000_g2752_i0	PRJNA1067370	2778	323	2.004	6.47292	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	553	6.819999999999998e-153	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g2752	i0	97.523	111.278637770898	323	8	100	0	1	323	51789	52111	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	35943	553	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212

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