metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJEB25583" and tax

7 rows where analysis = "blastn", bioproject = "PRJEB25583" 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
2261755	2261755	PRJEB25583_P_NODE_5162_length_181_cov_1.284722_g4985_i0	PRJEB25583	5162	181	1.284722	2.32534682	Leptotrichiaceae	1129771	Bacteria	Bacteria	309	8.26e-80	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g4985	i0	97.268	518.872928176796	183	3	100	2	1	181	918	736	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	93916	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
2572871	2572871	PRJEB25583_P_NODE_4123_length_200_cov_2.723926_g3946_i0	PRJEB25583	4123	200	2.723926	5.447852	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	327	2.58e-85	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g3946	i0	99.444	266.18	180	1	90	0	21	200	594242	594063	Leptotrichia sp. oral taxon 498, complete genome	blastn	53236	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
6401127	6401127	PRJEB25583_P_NODE_4546_length_192_cov_1.470968_g4369_i0	PRJEB25583	4546	192	1.470968	2.82425856	Leptotrichia wadei	157687	Bacteria	Bacteria	355	1.13e-93	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g4369	i0	100	131.901041666667	192	0	100	0	1	192	2244141	2244332	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	25325	355	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
9914592	9914592	PRJEB25583_P_NODE_6428_length_165_cov_1.757812_g6251_i0	PRJEB25583	6428	165	1.757812	2.9003898	Fusobacterium	848	Bacteria	Bacteria	272	9.73e-69	NTclustered	gi\|453201795\|gb\|JQ999703.1\|	159267	g6251	i0	96.364	430.369696969697	165	6	100	0	1	165	51	215	Uncultured Fusobacterium sp. clone GKJWQY101A4B9X 23S ribosomal RNA gene, partial sequence	blastn	71011	272	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	uncultured Fusobacterium sp.
13739908	13739908	PRJEB25583_P_NODE_5731_length_173_cov_1.610294_g5554_i0	PRJEB25583	5731	173	1.610294	2.78580862	Streptobacillus	34104	Bacteria	Bacteria	281	1.7e-71	NTclustered	gi\|470485174\|ref\|NR_076688.1\|	34105	g5554	i0	97.006	471.086705202312	167	5	97	0	7	173	1047	1213	Streptobacillus moniliformis strain DSM 12112 23S ribosomal RNA gene, complete sequence	blastn	81498	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
16289120	16289120	PRJEB25583_P_NODE_3713_length_210_cov_1.549133_g3536_i0	PRJEB25583	3713	210	1.549133	3.2531793	Leptotrichia	32067	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g3536	i0	100	0.266666666666667	28	0	13	0	95	122	845585	845558	Leptotrichia sp. oral taxon 498, complete genome	blastn	56	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
17874601	17874601	PRJEB25583_P_NODE_5535_length_176_cov_1.086331_g5358_i0	PRJEB25583	5535	176	1.086331	1.91194256	Fusobacterium gastrosuis	1755100	Bacteria	Bacteria	252	1.36e-62	NTclustered	gi\|1795735174\|emb\|LT607734.1\|	1755100	g5358	i0	92.571	507.693181818182	175	13	99	0	1	175	344790	344616	Fusobacterium sp. P6 Po strain Fusobacterium gastrosuis sp. nov. CDW1, P6 Po genome assembly, chromosome: chr	blastn	89354	252	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium gastrosuis

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