metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA681861" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA681861" 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
2446722	2446722	PRJNA681861_P_NODE_14602_length_423_cov_165.225888_g12530_i0	PRJNA681861	14602	423	165.225888	698.90550624	Fusobacterium	848	Bacteria	Bacteria	588	2.5099999999999993e-163	NTclustered	gi\|2573686249\|gb\|CP133474.1\|	851	g12530	i0	91.726	481.721040189125	423	35	100	0	1	423	322010	322432	Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome	blastn	203768	588	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
8310703	8310703	PRJNA681861_P_NODE_19927_length_317_cov_397.934028_g17827_i0	PRJNA681861	19927	317	397.934028	1261.45086876	Leptotrichia shahii	157691	Bacteria	Bacteria	307	5.74e-79	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g17827	i0	98.837	221	172	2	56	0	146	317	96233	96062	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	70057	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
14686605	14686605	PRJNA681861_P_NODE_14612_length_423_cov_3.964467_g12540_i0	PRJNA681861	14612	423	3.964467	16.76969541	Leptotrichia hofstadii	157688	Bacteria	Bacteria	518	3.34e-142	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g12540	i0	89.151	160.51536643026	424	14	100	10	1	423	2453808	2454200	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	67898	518	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
16474189	16474189	PRJNA681861_P_NODE_46893_length_151_cov_4.032787_g44793_i0	PRJNA681861	46893	151	4.032787	6.08950837	Leptotrichia	32067	Bacteria	Bacteria	274	2.42e-69	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g44793	i0	99.338	245.960264900662	151	1	100	0	1	151	234	84	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	37140	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
17235544	17235544	PRJNA681861_P_NODE_14934_length_414_cov_4.228571_g12859_i0	PRJNA681861	14934	414	4.228571	17.50628394	Leptotrichia hofstadii	157688	Bacteria	Bacteria	566	1.15e-156	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g12859	i0	91.807	201.942028985507	415	11	100	9	1	414	2454200	2453808	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	83604	566	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
20297741	20297741	PRJNA681861_P_NODE_18676_length_337_cov_373.821429_g16578_i0	PRJNA681861	18676	337	373.821429	1259.77821573	Leptotrichia	32067	Bacteria	Bacteria	612	1.16e-170	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g16578	i0	99.407	491.338278931751	337	2	100	0	1	337	1946	2282	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	165581	612	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
21060104	21060104	PRJNA681861_P_NODE_41937_length_178_cov_5.570470_g39837_i0	PRJNA681861	41937	178	5.57047	9.9154366	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	318	1.34e-82	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g39837	i0	98.876	41.4719101123596	178	2	100	0	1	178	51768	51591	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	7382	318	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
22334923	22334923	PRJNA681861_P_NODE_23338_length_273_cov_400.180328_g21238_i0	PRJNA681861	23338	273	400.180328	1092.49229544	Fusobacterium polymorphum	76857	Bacteria	Bacteria	366	7.88e-97	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g21238	i0	90.842	482.47619047619	273	25	100	0	1	273	192442	192170	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	131716	366	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
24123330	24123330	PRJNA681861_P_NODE_25459_length_251_cov_10.193694_g23359_i0	PRJNA681861	25459	251	10.193694	25.58617194	Fusobacterium	848	Bacteria	Bacteria	276	1.24e-69	NTclustered	gi\|586941090\|dbj\|AB910749.1\|	860	g23359	i0	100	130.820717131474	149	0	59	0	103	251	151	3	Fusobacterium periodonticum gene for 16S ribosomal RNA, partial sequence	blastn	32836	276	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum

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