metadata: contig_metadata: 7 rows where bioproject = "PRJNA564013", tax_phylum = "Mycoplasmatota" and tax

7 rows where bioproject = "PRJNA564013", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

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
14579530	14579530	PRJNA564013_P_NODE_296792_length_227_cov_5.265060_g293940_i0	PRJNA564013	296792	227	5.26506	11.9516862	Ureaplasma diversum	42094	Bacteria	Bacteria	91.6	4.28e-14	NTclustered	gi\|764071633\|gb\|CP009770.1\|	42094	g293940	i0	82.075	0.933920704845815	106	19	47	0	23	128	697593	697698	Ureaplasma diversum strain ATCC 49782 genome	blastn	212	91.6	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma diversum
15852697	15852697	PRJNA564013_P_NODE_260213_length_253_cov_3.713542_g257361_i0	PRJNA564013	260213	253	3.713542	9.39526126	Tenericutes bacterium ADurb.BinA155	1852922	Bacteria	Bacteria	90.9	2.58e-21	NR	OPZ33007.1	1852922	g257361	i0	75.4	2.02766798418972	57	14	67.6	0	62	232	23	79	OPZ33007.1 MAG: 30S ribosomal protein S13 [Tenericutes bacterium ADurb.BinA155]	diamond	513	90.9	1	Bacteria	Bacillati	Mycoplasmatota					Tenericutes bacterium ADurb.BinA155
20955347	20955347	PRJNA564013_P_NODE_97377_length_414_cov_14.045326_g94543_i0	PRJNA564013	97377	414	14.045326	58.14764964	Paulownia witches'-broom phytoplasma	39647	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|2074124807\|gb\|CP066882.1\|	39647	g94543	i0	100	0.0676328502415459	28	0	7	0	332	359	421562	421535	Paulownia witches'-broom phytoplasma strain Zhengzhou chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Paulownia witches'-broom phytoplasma
24084039	24084039	PRJNA564013_P_NODE_232779_length_276_cov_3.627907_g229927_i0	PRJNA564013	232779	276	3.627907	10.01302332	Mycoplasmatales bacterium	2023991	Bacteria	Bacteria	111	5.160000000000001e-27	NR	HXN54618.1	2023991	g229927	i0	73.9	1.5	69	18	75	0	208	2	8	76	HXN54618.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmatales bacterium]	diamond	414	111	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			Mycoplasmatales bacterium
29605176	29605176	PRJNA564013_P_NODE_23090_length_774_cov_70.106592_g20723_i0	PRJNA564013	23090	774	70.106592	542.62502208	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	79	2.88e-15	NR	MFA5037764.1	3018265	g20723	i0	64.2	0.205426356589147	53	19	20.5	0	738	580	1	53	MFA5037764.1 hypothetical protein [Candidatus Izemoplasmatales bacterium]	diamond	159	79	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales bacterium
31754330	31754330	PRJNA564013_P_NODE_171657_length_332_cov_5.612546_g168807_i0	PRJNA564013	171657	332	5.612546	18.63365272	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	62.8	5.91e-9	NR	WNE40425.1	2685873	g168807	i0	43.3	4.42771084337349	90	45	78.6	3	280	20	47	133	WNE40425.1 MAG: Formamidopyrimidine-DNA glycosylase [Mycoplasmataceae bacterium]	diamond	1470	62.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
32874036	32874036	PRJNA564013_P_NODE_249280_length_262_cov_2.194030_g246428_i0	PRJNA564013	249280	262	2.19403	5.7483586	Bacillati	1783272	Bacteria	Bacteria	54.3	3.7e-6	NR	MBI9009492.1	2231116	g246428	i0	47.9	2.74809160305344	48	25	55	0	241	98	284	331	MBI9009492.1 recombinase RecA [Mycoplasmatota bacterium]	diamond	720	54.7	0.992687385740402	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium

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