metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA792582" 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
2052857	2052857	PRJNA792582_P_NODE_34222_length_294_cov_1.742081_g33408_i0	PRJNA792582	34222	294	1.742081	5.12171814	Malacoplasma muris	2119	Bacteria	Bacteria	327	4.05e-85	NTclustered	gi\|2890642799\|gb\|CP177248.1\|	2119	g33408	i0	86.942	94.8639455782313	291	38	99	0	1	291	88002	88292	Malacoplasma muris strain RIII-4 chromosome, complete genome	blastn	27890	327	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
3328230	3328230	PRJNA792582_P_NODE_47223_length_258_cov_1.248649_g46409_i0	PRJNA792582	47223	258	1.248649	3.22151442	Malacoplasma muris	2119	Bacteria	Bacteria	259	1.29e-64	NTclustered	gi\|2890642799\|gb\|CP177248.1\|	2119	g46409	i0	84.884	49.062015503876	258	37	99	2	1	257	1041889	1041633	Malacoplasma muris strain RIII-4 chromosome, complete genome	blastn	12658	259	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
10143882	10143882	PRJNA792582_P_NODE_31848_length_306_cov_3.862661_g31034_i0	PRJNA792582	31848	306	3.862661	11.81974266	Mycoplasma	2093	Bacteria	Bacteria	84.2	1.01e-11	NTclustered	gi\|2040452726\|gb\|CP074573.1\|	2231116	g31034	i0	80.909	6.24509803921569	110	17	35	4	63	169	1703833	1703941	Tenericutes bacterium strain zrk4 chromosome, complete genome	blastn	1911	84.2	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
11419426	11419426	PRJNA792582_P_NODE_45929_length_261_cov_2.457447_g45115_i0	PRJNA792582	45929	261	2.457447	6.41393667	Mycoplasmoidales	2790996	Bacteria	Bacteria	383	7.43e-102	NTclustered	gi\|1563789200\|emb\|LR214962.1\|	2115	g45115	i0	93.103	329.659003831418	261	18	100	0	1	261	355853	355593	Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8	blastn	86041	383	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis fermentans
14805573	14805573	PRJNA792582_P_NODE_40232_length_277_cov_1.509804_g39418_i0	PRJNA792582	40232	277	1.509804	4.18215708	Malacoplasma iowae	2116	Bacteria	Bacteria	209	1.43e-49	NTclustered	gi\|2624200933\|gb\|CP129196.1\|	2116	g39418	i0	81.395	38.2815884476534	258	46	93	2	3	259	1052570	1052314	Malacoplasma iowae strain M820 chromosome, complete genome	blastn	10604	209	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
16079377	16079377	PRJNA792582_P_NODE_28793_length_322_cov_1.232932_g27979_i0	PRJNA792582	28793	322	1.232932	3.97004104	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	202	2.84e-47	NTclustered	gi\|2907625690\|emb\|OZ223250.1\|	1898209	g27979	i0	79.655	62.0124223602485	290	51	89	7	30	315	1439943	1439658	MAG: Acholeplasmataceae bacterium isolate c289da16-4743-485f-819d-17f5771af8e7 genome assembly, chromosome: 1	blastn	19968	202	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
16079453	16079453	PRJNA792582_P_NODE_37373_length_285_cov_1.070755_g36559_i0	PRJNA792582	37373	285	1.070755	3.05165175	Malacoplasma penetrans	28227	Bacteria	Bacteria	139	1.96e-28	NTclustered	gi\|47118307\|dbj\|BA000026.2\|	272633	g36559	i0	89.815	13.0280701754386	108	11	38	0	1	108	94980	95087	Mycoplasma penetrans HF-2 DNA, complete genome	blastn	3713	139	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
17355251	17355251	PRJNA792582_P_NODE_37354_length_285_cov_1.089623_g36540_i0	PRJNA792582	37354	285	1.089623	3.10542555	Malacoplasma penetrans	28227	Bacteria	Bacteria	311	3.9300000000000005e-80	NTclustered	gi\|47118307\|dbj\|BA000026.2\|	272633	g36540	i0	87.004	81.2561403508772	277	34	97	2	1	276	1271351	1271076	Mycoplasma penetrans HF-2 DNA, complete genome	blastn	23158	311	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans

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