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

5 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax_phylum = "Mycoplasmatota"

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
942421	942421	PRJNA966993_P_NODE_79101_length_256_cov_1.191257_g78649_i0	PRJNA966993	79101	256	1.191257	3.04961792	Candidatus Phytoplasma fraxini	35780	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2714275034\|gb\|CP146843.1\|	35780	g78649	i0	96.875	0.234375	32	1	13	0	212	243	5945	5976	Candidatus Phytoplasma fraxini isolate AshY1 chromosome, complete genome	blastn	60	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma fraxini
4770802	4770802	PRJNA966993_P_NODE_78304_length_257_cov_1.597826_g77852_i0	PRJNA966993	78304	257	1.597826	4.10641282	Spiroplasma clarkii	2139	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1199760831\|gb\|CP015819.1\|	2139	g77852	i0	100	0.217898832684825	28	0	11	0	169	196	1285735	1285708	Spiroplasma clarkii strain CN-5 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma clarkii
9870681	9870681	PRJNA966993_P_NODE_82188_length_251_cov_1.224719_g81736_i0	PRJNA966993	82188	251	1.224719	3.07404469	Candidatus Hepatoplasma vulgare	3132032	Bacteria	Bacteria	60.2	1.36e-4	NTclustered	gi\|2416256354\|dbj\|AP027131.1\|	3132032	g81736	i0	92.857	0.167330677290837	42	1	16	2	211	251	300786	300746	MAG: Candidatus Hepatoplasma vulgare Av-JP DNA, complete genome	blastn	42	60.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Hepatoplasma	Candidatus Hepatoplasma vulgare
20068571	20068571	PRJNA966993_P_NODE_100036_length_238_cov_2.406061_g99584_i0	PRJNA966993	100036	238	2.406061	5.72642518	Spiroplasma culicicola	216935	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|583840421\|gb\|CP006681.1\|	1276246	g99584	i0	100	0.121848739495798	29	0	12	0	33	61	493100	493128	Spiroplasma culicicola AES-1, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma culicicola
20391853	20391853	PRJNA966993_P_NODE_24056_length_429_cov_1.946629_g23609_i0	PRJNA966993	24056	429	1.946629	8.35103841	Spiroplasma	2132	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|2328117301\|dbj\|AP026933.1\|	2141	g23609	i0	100	0.473193473193473	29	0	7	0	15	43	383291	383319	Spiroplasma ixodetis sHm DNA, complete genome	blastn	203	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma ixodetis

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