metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJDB4470" and tax

16 rows where analysis = "blastn", bioproject = "PRJDB4470" 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
1284159	1284159	PRJDB4470_P_NODE_87602_length_186_cov_1.722628_g86447_i0	PRJDB4470	87602	186	1.722628	3.20408808	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	233	5.289999999999999e-57	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g86447	i0	89.305	107.860215053763	187	19	100	1	1	186	51744	51930	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	20062	233	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
2256476	2256476	PRJDB4470_P_NODE_111662_length_165_cov_0.879310_g110507_i0	PRJDB4470	111662	165	0.87931	1.4508615	Fusobacterium	848	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1721134154\|emb\|LR698955.1\|	851	g110507	i0	100	119.187878787879	165	0	100	0	1	165	2022157	2022321	Fusobacterium nucleatum isolate MGYG-HGUT-01347 genome assembly, chromosome: 1	blastn	19666	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
3835235	3835235	PRJDB4470_P_NODE_108324_length_166_cov_0.871795_g107169_i0	PRJDB4470	108324	166	0.871795	1.4471797	Leptotrichia wadei	157687	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g107169	i0	100	11.2710843373494	166	0	100	0	1	166	450811	450976	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	1871	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
7358940	7358940	PRJDB4470_P_NODE_13766_length_663_cov_4.356678_g12783_i0	PRJDB4470	13766	663	4.356678	28.88477514	Leptotrichia	32067	Bacteria	Bacteria	1142	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g12783	i0	98.31	521.559577677225	651	11	98	0	13	663	1645	995	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	345794	1147	0.995640802092415	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
8936684	8936684	PRJDB4470_P_NODE_67888_length_226_cov_1.175141_g66733_i0	PRJDB4470	67888	226	1.175141	2.65581866	Leptotrichia alba	3239304	Bacteria	Bacteria	390	3.749999999999999e-104	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g66733	i0	97.788	2	226	5	100	0	1	226	887756	887981	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	452	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
8936769	8936769	PRJDB4470_P_NODE_78108_length_203_cov_0.974026_g76953_i0	PRJDB4470	78108	203	0.974026	1.97727278	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	368	1.55e-97	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g76953	i0	99.505	318.635467980296	202	1	99	0	2	203	96125	96326	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	64683	368	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
10212810	10212810	PRJDB4470_P_NODE_98569_length_171_cov_1.672131_g97414_i0	PRJDB4470	98569	171	1.672131	2.85934401	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	309	7.7e-80	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g97414	i0	99.412	446.66081871345	170	1	99	0	1	170	54218	54387	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	76379	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
11487080	11487080	PRJDB4470_P_NODE_118870_length_163_cov_0.912281_g117715_i0	PRJDB4470	118870	163	0.912281	1.48701803	Fusobacterium polymorphum	76857	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g117715	i0	100	99.5950920245399	163	0	100	0	1	163	1690089	1689927	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	16234	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
11487303	11487303	PRJDB4470_P_NODE_25830_length_462_cov_2.484262_g24694_i0	PRJDB4470	25830	462	2.484262	11.47729044	Leptotrichia buccalis	40542	Bacteria	Bacteria	804	0	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g24694	i0	98.052	3.0021645021645	462	9	100	0	1	462	900434	899973	Leptotrichia buccalis DSM 1135, complete genome	blastn	1387	804	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
12762641	12762641	PRJDB4470_P_NODE_111891_length_165_cov_0.879310_g110736_i0	PRJDB4470	111891	165	0.87931	1.4508615	Leptotrichia wadei	157687	Bacteria	Bacteria	300	4.46e-77	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g110736	i0	99.394	10.8545454545455	165	1	100	0	1	165	289280	289444	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	1791	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
12763081	12763081	PRJDB4470_P_NODE_46611_length_306_cov_2.494163_g45458_i0	PRJDB4470	46611	306	2.494163	7.63213878	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g45458	i0	94.118	0.111111111111111	34	2	11	0	57	90	1247404	1247371	Leptotrichia sp. SK-5 DNA, complete genome	blastn	34	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
15311818	15311818	PRJDB4470_P_NODE_58213_length_256_cov_1.821256_g57058_i0	PRJDB4470	58213	256	1.821256	4.66241536	Leptotrichia wadei	157687	Bacteria	Bacteria	457	4.22e-124	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g57058	i0	98.828	152.9296875	256	3	100	0	1	256	2243981	2244236	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	39150	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
16586552	16586552	PRJDB4470_P_NODE_61814_length_244_cov_1.394872_g60659_i0	PRJDB4470	61814	244	1.394872	3.40348768	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	324	4.22e-84	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g60659	i0	90.65	90.7090163934426	246	19	100	4	1	244	51767	52010	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	22133	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
21383383	21383383	PRJDB4470_P_NODE_108697_length_166_cov_0.871795_g107542_i0	PRJDB4470	108697	166	0.871795	1.4471797	Fusobacterium	848	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g107542	i0	100	81.1867469879518	166	0	100	0	1	166	493438	493603	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	13477	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
22960993	22960993	PRJDB4470_P_NODE_105239_length_167_cov_0.864407_g104084_i0	PRJDB4470	105239	167	0.864407	1.44355969	Leptotrichia shahii	157691	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g104084	i0	100	3.0059880239521	167	0	100	0	1	167	55419	55585	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	502	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
22960994	22960994	PRJDB4470_P_NODE_105299_length_167_cov_0.864407_g104144_i0	PRJDB4470	105299	167	0.864407	1.44355969	Fusobacterium polymorphum	76857	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|2706056059\|gb\|CP077188.1\|	76857	g104144	i0	100	80.9580838323353	167	0	100	0	1	167	88440	88274	Fusobacterium polymorphum strain SB028 chromosome, complete genome	blastn	13520	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum

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