metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1047551" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1047551" 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
174508	174508	PRJNA1047551_S_NODE_1121_length_421_cov_2.248705_g994_i0	PRJNA1047551	1121	421	2.248705	9.46704805	Leptotrichia hofstadii	157688	Bacteria	Bacteria	756	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g994	i0	99.05	266.501187648456	421	4	100	0	1	421	497871	498291	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	112197	756	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
1449230	1449230	PRJNA1047551_S_NODE_13282_length_152_cov_1.119658_g13155_i0	PRJNA1047551	13282	152	1.119658	1.70188016	Leptotrichia hofstadii	157688	Bacteria	Bacteria	237	3.2e-58	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g13155	i0	94.771	157.763157894737	153	7	100	1	1	152	576521	576673	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	23980	237	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
15037518	15037518	PRJNA1047551_S_NODE_5532_length_208_cov_3.693642_g5405_i0	PRJNA1047551	5532	208	3.693642	7.68277536	Leptotrichia	32067	Bacteria	Bacteria	385	1.58e-102	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g5405	i0	100	499.336538461538	208	0	100	0	1	208	734	941	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	103862	385	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
18026516	18026516	PRJNA1047551_S_NODE_7115_length_189_cov_3.629870_g6988_i0	PRJNA1047551	7115	189	3.62987	6.8604543	Leptotrichia wadei	157687	Bacteria	Bacteria	322	1.12e-83	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g6988	i0	97.368	547.238095238095	190	3	100	2	1	189	2368994	2368806	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	103428	322	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
23962276	23962276	PRJNA1047551_S_NODE_1139_length_418_cov_3.493473_g1012_i0	PRJNA1047551	1139	418	3.493473	14.60271714	Leptotrichia	32067	Bacteria	Bacteria	723	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g1012	i0	97.847	287.983253588517	418	9	100	0	1	418	1608	1191	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	120377	728	0.993131868131868	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);;