metadata: contig_metadata: 14 rows where bioproject = "PRJNA505329" and tax

14 rows where bioproject = "PRJNA505329" 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
483187	483187	PRJNA505329_P_NODE_17621_length_219_cov_6.511765_g17150_i0	PRJNA505329	17621	219	6.511765	14.26076535	Ureaplasma sp.	1965234	Bacteria	Bacteria	394	2.79e-105	NTclustered	gi\|2624684045\|gb\|OR879216.1\|	1965234	g17150	i0	99.537	94.0502283105023	216	1	99	0	1	216	1376	1161	Ureaplasma sp. strain 2674 16S ribosomal RNA gene, partial sequence	blastn	20597	394	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma sp.
1110399	1110399	PRJNA505329_P_NODE_44681_length_166_cov_5.735043_g44210_i0	PRJNA505329	44681	166	5.735043	9.52017138	Mollicutes	31969	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|281186773\|gb\|GU227378.1\|	2100	g44210	i0	100	99.2048192771084	163	0	98	0	3	165	1186	1024	Mycoplasma hyorhinis strain USP36P 16S ribosomal RNA gene, partial sequence	blastn	16468	302	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
7488380	7488380	PRJNA505329_P_NODE_26206_length_192_cov_3.573427_g25735_i0	PRJNA505329	26206	192	3.573427	6.86097984	Acholeplasma	2147	Bacteria	Bacteria	100	5.82e-17	NTclustered	gi\|294768449\|gb\|GU905034.1\|	264634	g25735	i0	82.051	13.6614583333333	117	21	61	0	71	187	1157	1273	Acholeplasma equifetale strain ATCC 29724 23S ribosomal RNA gene, partial sequence; 23S-5S ribosomal RNA intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	2623	100	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma equifetale
7488467	7488467	PRJNA505329_P_NODE_40726_length_171_cov_1.303279_g40255_i0	PRJNA505329	40726	171	1.303279	2.22860709	Bacillati	1783272	Bacteria	Bacteria	305	9.96e-79	NTclustered	gi\|2668342370\|gb\|CP143577.1\|	2094	g40255	i0	99.405	103.847953216374	168	1	98	0	1	168	374454	374621	Mycoplasmopsis arginini strain NCTC 10129 chromosome, complete genome	blastn	17758	305	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
13237546	13237546	PRJNA505329_P_NODE_7091_length_275_cov_4.030973_g6620_i0	PRJNA505329	7091	275	4.030973	11.08517575	Ureaplasma felinum	42095	Bacteria	Bacteria	307	4.89e-79	NTclustered	gi\|306410980\|gb\|HM197716.1\|	42095	g6620	i0	85.664	89.1927272727273	286	27	99	7	4	275	3755	4040	Ureaplasma felinum strain ATCC 49229 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24528	307	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma felinum
13864022	13864022	PRJNA505329_P_NODE_21011_length_201_cov_3.342105_g20540_i0	PRJNA505329	21011	201	3.342105	6.71763105	Bacteria	2	Bacteria	Bacteria	95.3	2.86e-15	NTclustered	gi\|2209672355\|gb\|ON023780.1\|	2124	g20540	i0	90.278	6.15422885572139	72	7	36	0	30	101	1440	1369	Metamycoplasma salivarium strain ATCC 14277 23S ribosomal RNA gene, partial sequence	blastn	1237	95.3	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma salivarium
15786125	15786125	PRJNA505329_P_NODE_35073_length_179_cov_3.030769_g34602_i0	PRJNA505329	35073	179	3.030769	5.42507651	Ureaplasma diversum	42094	Bacteria	Bacteria	244	2.33e-60	NTclustered	gi\|764071633\|gb\|CP009770.1\|	42094	g34602	i0	92.045	99.3072625698324	176	11	98	3	1	176	141468	141296	Ureaplasma diversum strain ATCC 49782 genome	blastn	17776	244	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma diversum
16412928	16412928	PRJNA505329_P_NODE_18813_length_205_cov_1.294872_g18342_i0	PRJNA505329	18813	205	1.294872	2.6544876	Mesomycoplasma	2923352	Bacteria	Bacteria	372	1.21e-98	NTclustered	gi\|1958638505\|gb\|MW498314.1\|	2100	g18342	i0	100	102.882926829268	201	0	98	0	1	201	1686	1486	Mesomycoplasma hyorhinis strain MycSu128 23S ribosomal RNA gene, partial sequence	blastn	21091	372	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
17688239	17688239	PRJNA505329_P_NODE_41814_length_169_cov_1.708333_g41343_i0	PRJNA505329	41814	169	1.708333	2.88708277	Mycoplasmopsis	2767358	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|2496025365\|gb\|CP123300.1\|	28903	g41343	i0	99.398	185.615384615385	166	1	98	0	4	169	483203	483038	Mycoplasmopsis bovis strain 15DD0238 chromosome, complete genome	blastn	31369	302	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
17688241	17688241	PRJNA505329_P_NODE_4234_length_392_cov_4.504373_g3769_i0	PRJNA505329	4234	392	4.504373	17.65714216	Ureaplasma	2129	Bacteria	Bacteria	688	0	NTclustered	gi\|2177595200\|gb\|CP086123.1\|	2130	g3769	i0	98.462	150.219387755102	390	6	99	0	3	392	345449	345838	Ureaplasma urealyticum strain MIN-201 chromosome, complete genome	blastn	58886	688	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma urealyticum
18335309	18335309	PRJNA505329_P_NODE_52295_length_153_cov_2.961538_g51824_i0	PRJNA505329	52295	153	2.961538	4.53115314	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	272	8.84e-69	NTclustered	gi\|2668342370\|gb\|CP143577.1\|	2094	g51824	i0	99.338	83.8888888888889	151	0	98	1	1	150	5629	5479	Mycoplasmopsis arginini strain NCTC 10129 chromosome, complete genome	blastn	12835	272	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
18961853	18961853	PRJNA505329_P_NODE_18335_length_210_cov_1.919255_g17864_i0	PRJNA505329	18335	210	1.919255	4.0304355	Mollicutes	31969	Bacteria	Bacteria	292	9.97e-75	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g17864	i0	96.111	89.1095238095238	180	5	85	2	4	182	19698	19520	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	18713	292	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
24062411	24062411	PRJNA505329_P_NODE_839_length_1353_cov_8.873466_g644_i0	PRJNA505329	839	1353	8.873466	120.05799498	Ureaplasma	2129	Bacteria	Bacteria	1687	0	NTclustered	gi\|306410979\|gb\|HM197715.1\|	42093	g644	i0	89.325	113.736141906874	1349	131	99	13	10	1350	3241	1898	Ureaplasma cati strain ATCC 49228 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	153885	1694	0.995867768595041	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma cati
25336642	25336642	PRJNA505329_P_NODE_17480_length_221_cov_3.686047_g17009_i0	PRJNA505329	17480	221	3.686047	8.14616387	FCB group	1783270	Bacteria	Bacteria	215	2.36e-51	NTclustered	gi\|523500278\|gb\|KC686357.1\|	2100	g17009	i0	100	85.2217194570136	116	0	52	0	103	218	81	196	Mycoplasma hyorhinis isolate 92Mhyor 16S ribosomal RNA gene, partial sequence	blastn	18834	215	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis

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