metadata: contig_metadata: 5 rows where bioproject = "PRJNA1005695" and tax

5 rows where bioproject = "PRJNA1005695" 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
7378654	7378654	PRJNA1005695_P_NODE_23066_length_313_cov_1.079167_g22214_i0	PRJNA1005695	23066	313	1.079167	3.37779271	Ureaplasma	2129	Bacteria	Bacteria	460	4.1e-125	NTclustered	gi\|2177595200\|gb\|CP086123.1\|	2130	g22214	i0	93.312	148.817891373802	314	18	100	2	1	313	149348	149037	Ureaplasma urealyticum strain MIN-201 chromosome, complete genome	blastn	46580	460	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma urealyticum
9080847	9080847	PRJNA1005695_P_NODE_10128_length_488_cov_2.301205_g9277_i0	PRJNA1005695	10128	488	2.301205	11.2298804	Spiroplasma melliferum	2134	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|1634056650\|gb\|CP029202.1\|	2134	g9277	i0	92.5	0.0819672131147541	40	2	8	1	341	379	483308	483269	Spiroplasma melliferum strain AS576 chromosome, complete genome	blastn	40	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma melliferum
26749170	26749170	PRJNA1005695_P_NODE_36561_length_249_cov_0.886364_g35709_i0	PRJNA1005695	36561	249	0.886364	2.20704636	Candidatus Faecisoma merdavium	2840801	Bacteria	Bacteria	83.2	2.37e-16	NR	HIS90442.1	2840801	g35709	i0	48.7	4.74698795180723	78	40	94	0	240	7	192	269	HIS90442.1 aryl-sulfate sulfotransferase [Candidatus Faecisoma merdavium]	diamond	1182	83.2	1	Bacteria	Bacillati	Mycoplasmatota				Candidatus Faecisoma	Candidatus Faecisoma merdavium
27855724	27855724	PRJNA1005695_P_NODE_35125_length_252_cov_0.871508_g34273_i0	PRJNA1005695	35125	252	0.871508	2.19620016	Candidatus Phytoplasma bonamiae	2982626	Bacteria	Bacteria	125	1.65e-34	NR	MDV3174936.1	2982626	g34273	i0	69	1	84	26	100	0	252	1	46	129	MDV3174936.1 EF-Tu/IF-2/RF-3 family GTPase [Candidatus Phytoplasma bonamiae]	diamond	252	125	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma bonamiae
31899383	31899383	PRJNA1005695_P_NODE_17217_length_364_cov_2.591065_g16365_i0	PRJNA1005695	17217	364	2.591065	9.4314766	Mycoplasmatales bacterium	2023991	Bacteria	Bacteria	129	2.1999999999999994e-33	NR	HXN54616.1	2023991	g16365	i0	56.7	0.989010989010989	120	49	98.9	1	2	361	192	308	HXN54616.1 F0F1 ATP synthase subunit alpha [Mycoplasmatales bacterium]	diamond	360	129	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			Mycoplasmatales 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);;