metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA853194" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA853194" 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
3786432	3786432	PRJNA853194_S_NODE_49703_length_308_cov_1.800000_g48612_i0	PRJNA853194	49703	308	1.8	5.544	Spiroplasma	2132	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2802839268\|emb\|OZ181653.1\|	3066280	g48612	i0	100	0.282467532467532	28	0	9	0	147	174	956580	956607	Spiroplasma endosymbiont of Rhagonycha fulva isolate 54749 genome assembly, chromosome: 1	blastn	87	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Rhagonycha fulva
5943800	5943800	PRJNA853194_S_NODE_52185_length_301_cov_2.359649_g51094_i0	PRJNA853194	52185	301	2.359649	7.10254349	Spiroplasma endosymbiont of Anurida maritima	2967972	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2812212550\|gb\|CP102059.1\|	2967972	g51094	i0	92.5	0.132890365448505	40	2	13	1	67	105	375099	375138	Spiroplasma endosymbiont of Anurida maritima isolate Wells-next-the-Sea chromosome, complete genome	blastn	40	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Anurida maritima
5943897	5943897	PRJNA853194_S_NODE_56445_length_291_cov_1.036697_g55354_i0	PRJNA853194	56445	291	1.036697	3.01678827	Mycoplasma wenyonii	65123	Bacteria	Bacteria	276	1.47e-69	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g55354	i0	83.959	1.00687285223368	293	41	99	4	1	290	247862	247573	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	293	276	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
8493975	8493975	PRJNA853194_S_NODE_76407_length_251_cov_1.376404_g75316_i0	PRJNA853194	76407	251	1.376404	3.45477404	Spiroplasma phoeniceum	47835	Bacteria	Bacteria	58.4	4.89e-4	NTclustered	gi\|1434284537\|gb\|CP031088.1\|	1276259	g75316	i0	97.143	0.139442231075697	35	0	14	1	94	127	1709910	1709944	Spiroplasma phoeniceum P40 chromosome, complete genome	blastn	35	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma phoeniceum
9767914	9767914	PRJNA853194_S_NODE_17508_length_472_cov_3.746867_g16419_i0	PRJNA853194	17508	472	3.746867	17.68521224	Candidatus Phytoplasma fraxini	35780	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2714275034\|gb\|CP146843.1\|	35780	g16419	i0	100	0.0593220338983051	28	0	6	0	412	439	530093	530066	Candidatus Phytoplasma fraxini isolate AshY1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma fraxini
12320483	12320483	PRJNA853194_S_NODE_87050_length_232_cov_2.421384_g85959_i0	PRJNA853194	87050	232	2.421384	5.61761088	Mycoplasma wenyonii	65123	Bacteria	Bacteria	412	8.26e-111	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g85959	i0	98.707	1.99568965517241	232	3	100	0	1	232	540265	540496	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	463	412	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16143250	16143250	PRJNA853194_S_NODE_45613_length_320_cov_1.858300_g44522_i0	PRJNA853194	45613	320	1.8583	5.94656	Mycoplasma wenyonii	65123	Bacteria	Bacteria	449	9.11e-122	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g44522	i0	91.95	1.009375	323	22	100	4	1	320	581456	581777	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	323	449	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16143505	16143505	PRJNA853194_S_NODE_58473_length_286_cov_1.446009_g57382_i0	PRJNA853194	58473	286	1.446009	4.13558574	Mycoplasma wenyonii	65123	Bacteria	Bacteria	303	6.61e-78	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g57382	i0	86.316	0.996503496503496	285	32	97	5	1	278	163601	163317	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	285	303	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
17418721	17418721	PRJNA853194_S_NODE_47414_length_315_cov_1.297521_g46323_i0	PRJNA853194	47414	315	1.297521	4.08719115	Spiroplasma ixodetis	2141	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2522717419\|gb\|CP127039.1\|	1276219	g46323	i0	100	0.0888888888888889	28	0	9	0	96	123	1156347	1156320	Spiroplasma ixodetis Y32 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma ixodetis
22517017	22517017	PRJNA853194_S_NODE_36918_length_350_cov_2.368231_g35827_i0	PRJNA853194	36918	350	2.368231	8.2888085	Mycoplasmopsis bovis	28903	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|1951464263\|gb\|CP058416.1\|	28903	g35827	i0	100	0.08	28	0	8	0	163	190	204913	204940	Mycoplasmopsis bovis strain Mb200 chromosome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis

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