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

5 rows where analysis = "blastn", bioproject = "PRJEB28062" 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
5127537	5127537	PRJEB28062_P_NODE_60425_length_450_cov_7.419098_g58065_i0	PRJEB28062	60425	450	7.419098	33.385941	Spiroplasma endosymbiont of Othius punctulatus	3066289	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2706542394\|emb\|OZ026449.1\|	3066289	g58065	i0	100	0.0666666666666667	30	0	7	0	175	204	691707	691678	Spiroplasma endosymbiont of Othius punctulatus isolate 54758 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Othius punctulatus
11502892	11502892	PRJEB28062_P_NODE_47250_length_522_cov_4.418708_g44905_i0	PRJEB28062	47250	522	4.418708	23.06565576	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	121	1.3800000000000001e-22	NTclustered	gi\|2187152065\|emb\|OV788643.1\|	658143	g44905	i0	94.805	1.30651340996169	77	4	15	0	306	382	955792	955716	uncultured Tenericutes bacterium isolate min17_bin32 genome assembly, chromosome: 1	blastn	682	121	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
14051909	14051909	PRJEB28062_P_NODE_117652_length_266_cov_3.051813_g115289_i0	PRJEB28062	117652	266	3.051813	8.11782258	Candidatus Phytoplasma oryzae	203274	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2430437647\|gb\|CP116038.1\|	203274	g115289	i0	100	0.105263157894737	28	0	11	0	79	106	360852	360879	Candidatus Phytoplasma oryzae strain HN2022 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma oryzae
17565394	17565394	PRJEB28062_P_NODE_47154_length_522_cov_98.483296_g44809_i0	PRJEB28062	47154	522	98.483296	514.08280512	Malacoplasma	2791001	Bacteria	Bacteria	608	2.419999999999999e-169	NTclustered	gi\|470476279\|ref\|NR_076329.1\|	28227	g44809	i0	88.69	134.92337164751	504	49	96	8	1	500	503	4	Mycoplasma penetrans strain HF-2 23S ribosomal RNA gene, complete sequence	blastn	70430	608	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
19149183	19149183	PRJEB28062_P_NODE_11256_length_1148_cov_11.173023_g9575_i0	PRJEB28062	11256	1148	11.173023	128.26630404	Malacoplasma muris	2119	Bacteria	Bacteria	1489	0	NTclustered	gi\|299851933\|gb\|HM135461.1\|	2119	g9575	i0	90.208	119.160278745645	1154	95	100	16	1	1148	333	1474	Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence	blastn	136796	1489	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris

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