metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA734348" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA734348" 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
2472909	2472909	PRJNA734348_P_NODE_85902_length_255_cov_2.807692_g85204_i0	PRJNA734348	85902	255	2.807692	7.1596146	Mollicutes	31969	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1432057116\|gb\|CP029295.1\|	142651	g85204	i0	90.244	0.270588235294118	41	2	16	2	95	135	185391	185429	[Mycoplasma] phocae strain 105 chromosome, complete genome	blastn	69	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	[Mycoplasma] phocae
3268387	3268387	PRJNA734348_P_NODE_119843_length_244_cov_0.900585_g119145_i0	PRJNA734348	119843	244	0.900585	2.1974274	uncultured Mycoplasma sp.	167967	Bacteria	Bacteria	58.4	4.73e-4	NTclustered	gi\|1775571725\|gb\|MN692881.1\|	167967	g119145	i0	82.09	0.549180327868853	67	12	27	0	56	122	708	642	Uncultured Mycoplasma sp. clone 35a 23S ribosomal RNA gene, partial sequence	blastn	134	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	uncultured Mycoplasma sp.
10126070	10126070	PRJNA734348_P_NODE_71288_length_268_cov_2.548718_g70590_i0	PRJNA734348	71288	268	2.548718	6.83056424	Mesomycoplasma	2923352	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g70590	i0	100	15	268	0	100	0	1	268	679726	679993	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4020	496	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
14746082	14746082	PRJNA734348_P_NODE_123512_length_243_cov_0.905882_g122814_i0	PRJNA734348	123512	243	0.905882	2.20129326	Mycoplasmopsis pulmonis	2107	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1563796921\|emb\|LR215008.1\|	2107	g122814	i0	100	125.460905349794	243	0	100	0	1	243	799419	799177	Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1	blastn	30487	449	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis pulmonis
21599163	21599163	PRJNA734348_P_NODE_143877_length_227_cov_2.168831_g143179_i0	PRJNA734348	143877	227	2.168831	4.92324637	Mesomycoplasma	2923352	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g143179	i0	100	15.9911894273128	227	0	100	0	1	227	390367	390141	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3630	420	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
22396376	22396376	PRJNA734348_P_NODE_80258_length_260_cov_2.326203_g79560_i0	PRJNA734348	80258	260	2.326203	6.0481278	Mycoplasmopsis felis	33923	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2695674525\|gb\|CP141047.2\|	33923	g79560	i0	100	1.84615384615385	30	0	12	0	165	194	17630	17659	Mycoplasmopsis felis strain 99014 chromosome, complete genome	blastn	480	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis felis
23670296	23670296	PRJNA734348_P_NODE_129599_length_242_cov_0.911243_g128901_i0	PRJNA734348	129599	242	0.911243	2.20520806	Mycoplasma wenyonii	65123	Bacteria	Bacteria	403	5.22e-108	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g128901	i0	96.694	1	242	8	100	0	1	242	138627	138868	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	242	403	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24148514	24148514	PRJNA734348_P_NODE_128859_length_242_cov_0.911243_g128161_i0	PRJNA734348	128859	242	0.911243	2.20520806	Mesomycoplasma	2923352	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g128161	i0	100	15	242	0	100	0	1	242	403655	403414	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3630	448	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
24149129	24149129	PRJNA734348_P_NODE_79519_length_261_cov_1.526596_g78821_i0	PRJNA734348	79519	261	1.526596	3.98441556	Mesomycoplasma	2923352	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g78821	i0	100	16.0038314176245	261	0	100	0	1	261	457453	457193	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4177	483	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);;