metadata: contig_metadata: 6 rows where bioproject = "PRJNA745553", tax_kingdom = "Bacillati" and tax

6 rows where bioproject = "PRJNA745553", tax_kingdom = "Bacillati" 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
4552713	4552713	PRJNA745553_S_NODE_21024_length_269_cov_10.117347_g20829_i0	PRJNA745553	21024	269	10.117347	27.21566343	uncultured Spiroplasma sp.	319049	Bacteria	Bacteria	228	3.809999999999999e-55	NTclustered	gi\|1899225355\|gb\|MT967821.1\|	319049	g20829	i0	88.77	208.691449814126	187	20	69	1	26	211	2078	2264	Uncultured Spiroplasma sp. clone asv_320_2264 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	56138	228	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	uncultured Spiroplasma sp.
7102961	7102961	PRJNA745553_S_NODE_26026_length_244_cov_1.216374_g25831_i0	PRJNA745553	26026	244	1.216374	2.96795256	Ureaplasma zalophigenitalium	907723	Bacteria	Bacteria	172	1.62e-38	NTclustered	gi\|309385701\|gb\|HQ377518.1\|	907723	g25831	i0	79.92	98.6065573770492	249	39	100	9	1	244	3484	3242	Ureaplasma zalophigenitalium strain CSL7644-GEN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24060	172	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma zalophigenitalium
11402385	11402385	PRJNA745553_S_NODE_17669_length_293_cov_7.686364_g17474_i0	PRJNA745553	17669	293	7.686364	22.52104652	Bacteria	2	Bacteria	Bacteria	473	4.889999999999999e-129	NTclustered	gi\|2606493072\|gb\|CP136954.1\|	3081164	g17474	i0	98.155	147.518771331058	271	5	92	0	14	284	389208	389478	Mollicutes bacterium LVI A0075 chromosome, complete genome	blastn	43223	473	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium LVI A0075
13478137	13478137	PRJNA745553_S_NODE_29071_length_224_cov_19.079470_g28876_i0	PRJNA745553	29071	224	19.07947	42.7380128	Acholeplasma sp. G383	398172	Bacteria	Bacteria	58.4	4.28e-4	NTclustered	gi\|111283641\|gb\|DQ840503.1\|	398172	g28876	i0	89.13	3.1875	46	5	21	0	25	70	282	327	Acholeplasma sp. G383 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	714	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma sp. G383
19851256	19851256	PRJNA745553_S_NODE_23756_length_253_cov_7.083333_g23561_i0	PRJNA745553	23756	253	7.083333	17.92083249	uncultured Ureaplasma sp.	293430	Bacteria	Bacteria	272	1.6199999999999996e-68	NTclustered	gi\|1899225129\|gb\|MT967601.1\|	293430	g23561	i0	89.091	103.051383399209	220	23	87	1	24	242	1744	1963	Uncultured Ureaplasma sp. clone asv_100_2225 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26072	272	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	uncultured Ureaplasma sp.
23677100	23677100	PRJNA745553_S_NODE_15719_length_311_cov_1.886555_g15524_i0	PRJNA745553	15719	311	1.886555	5.86718605	uncultured Ureaplasma sp.	293430	Bacteria	Bacteria	416	8.95e-112	NTclustered	gi\|1899225129\|gb\|MT967601.1\|	293430	g15524	i0	90.968	116.694533762058	310	27	99	1	2	310	2225	1916	Uncultured Ureaplasma sp. clone asv_100_2225 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36292	416	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	uncultured Ureaplasma sp.

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