metadata: contig_metadata: 8 rows where bioproject = "PRJEB3181" and tax

8 rows where bioproject = "PRJEB3181" 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
7708466	7708466	PRJEB3181_S_NODE_5267_length_263_cov_501.719298_g4974_i0	PRJEB3181	5267	263	501.719298	1319.52175374	uncultured Ureaplasma sp.	293430	Bacteria	Bacteria	191	4.88e-44	NTclustered	gi\|1899225129\|gb\|MT967601.1\|	293430	g4974	i0	82.589	68.5855513307985	224	32	84	7	21	240	1965	1745	Uncultured Ureaplasma sp. clone asv_100_2225 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	18038	191	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	uncultured Ureaplasma sp.
11534156	11534156	PRJEB3181_P_NODE_25990_length_157_cov_5.246032_g25725_i0	PRJEB3181	25990	157	5.246032	8.23627024	Acholeplasma sp. G383	398172	Bacteria	Bacteria	58.4	2.78e-4	NTclustered	gi\|111283641\|gb\|DQ840503.1\|	398172	g25725	i0	89.13	4.54777070063694	46	5	29	0	110	155	327	282	Acholeplasma sp. G383 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	714	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma sp. G383
16632803	16632803	PRJEB3181_P_NODE_15334_length_214_cov_16.153005_g15070_i0	PRJEB3181	15334	214	16.153005	34.5674307	uncultured Ureaplasma sp.	293430	Bacteria	Bacteria	191	3.83e-44	NTclustered	gi\|1899225129\|gb\|MT967601.1\|	293430	g15070	i0	83.654	80.0981308411215	208	28	96	6	10	214	1948	1744	Uncultured Ureaplasma sp. clone asv_100_2225 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17141	191	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	uncultured Ureaplasma sp.
16632931	16632931	PRJEB3181_S_NODE_14354_length_171_cov_1.161765_g14061_i0	PRJEB3181	14354	171	1.161765	1.98661815	Spiroplasma endosymbiont of Aspidapion aeneum	3066276	Bacteria	Bacteria	58.4	3.08e-4	NTclustered	gi\|2719904881\|emb\|OZ034994.1\|	3066276	g14061	i0	81.333	0.964912280701754	75	10	42	4	15	86	944841	944768	Spiroplasma endosymbiont of Aspidapion aeneum isolate 54746 genome assembly, chromosome: 1	blastn	165	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Aspidapion aeneum
17566674	17566674	PRJEB3181_S_NODE_13934_length_173_cov_3.434783_g13641_i0	PRJEB3181	13934	173	3.434783	5.94217459	Mycoplasmoidaceae	2790998	Bacteria	Bacteria	187	3.82e-43	NTclustered	gi\|119369652\|gb\|EF061769.1\|	2097	g13641	i0	91.241	94.1387283236994	137	12	79	0	4	140	196	60	Mycoplasma genitalium strain ATCC 33530 23S ribosomal RNA gene, partial sequence	blastn	16286	187	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Mycoplasmoides	Mycoplasmoides genitalium
19181541	19181541	PRJEB3181_S_NODE_1756_length_386_cov_45.002849_g1465_i0	PRJEB3181	1756	386	45.002849	173.71099714	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	257	7.28e-64	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g1465	i0	82.333	356.036269430052	300	50	77	3	2	300	373472	373769	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	137430	257	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
23008179	23008179	PRJEB3181_S_NODE_4779_length_274_cov_27065.142259_g4486_i0	PRJEB3181	4779	274	27065.142259	74158.48978966	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	375	1.3099999999999998e-99	NTclustered	gi\|2579242005\|gb\|CP125275.1\|	2685873	g4486	i0	97.285	24.4598540145985	221	6	81	0	54	274	543318	543538	MAG: Mycoplasmataceae bacterium isolate AD185 chromosome, complete genome	blastn	6702	375	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
31708386	31708386	PRJEB3181_P_NODE_18197_length_194_cov_2.723926_g17933_i0	PRJEB3181	18197	194	2.723926	5.28441644	Mycoplasmoidaceae bacterium	2854035	Bacteria	Bacteria	43.1	0.01	NR	GMO17728.1	2854035	g17933	i0	50	0.649484536082474	42	21	64.9	0	4	129	135	176	GMO17728.1 MAG: hypothetical protein Ta2E_08820 [Mycoplasmoidaceae bacterium]	diamond	126	43.1	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae		Mycoplasmoidaceae 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);;