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

5 rows where analysis = "blastn", bioproject = "PRJNA309466" 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
6165729	6165729	PRJNA309466_P_NODE_12285_length_185_cov_1.058824_g12228_i0	PRJNA309466	12285	185	1.058824	1.9588244	root	1	Root_unresolved	Root_unresolved	327	2.34e-85	NTclustered	gi\|255694003\|gb\|FJ471660.2\|	851	g12228	i0	99.444	131.356756756757	180	1	97	0	6	185	565	744	Fusobacterium nucleatum strain ChDC F318 16S ribosomal RNA gene, partial sequence	blastn	24301	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
19502804	19502804	PRJNA309466_P_NODE_16676_length_166_cov_0.888889_g16619_i0	PRJNA309466	16676	166	0.888889	1.47555574	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	279	5.86e-71	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g16619	i0	96.988	10.8915662650602	166	5	100	0	1	166	586946	586781	Leptotrichia sp. SK-5 DNA, complete genome	blastn	1808	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
21464906	21464906	PRJNA309466_P_NODE_5937_length_240_cov_3.308901_g5880_i0	PRJNA309466	5937	240	3.308901	7.9413624	Fusobacterium	848	Bacteria	Bacteria	411	3.089999999999999e-110	NTclustered	gi\|285798258\|gb\|GU408240.1\|	851	g5880	i0	100	122.1375	222	0	93	0	9	230	280	59	Fusobacterium nucleatum clone OEA050 16S ribosomal RNA gene, partial sequence	blastn	29313	411	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
22053385	22053385	PRJNA309466_P_NODE_5078_length_256_cov_1.801932_g5021_i0	PRJNA309466	5078	256	1.801932	4.61294592	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	470	5.42e-128	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g5021	i0	100	472.07421875	254	0	99	0	3	256	736846	736593	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	120851	470	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
24014818	24014818	PRJNA309466_P_NODE_1259_length_655_cov_3.508251_g1217_i0	PRJNA309466	1259	655	3.508251	22.97904405	Fusobacterium	848	Bacteria	Bacteria	1142	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g1217	i0	99.058	464.302290076336	637	5	98	1	4	640	462734	463369	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	304118	1147	0.995640802092415	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);;