metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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
2731038	2731038	PRJNA1067370_P_NODE_102823_length_244_cov_1.105263_g102274_i0	PRJNA1067370	102823	244	1.105263	2.69684172	Mycoplasma feriruminatoris	1179777	Bacteria	Bacteria	124	4.599999999999999e-24	NTclustered	gi\|2483644534\|gb\|CP113499.1\|	1179777	g102274	i0	81.879	1.95491803278689	149	26	61	1	77	224	73259	73111	Mycoplasma feriruminatoris strain L15407 chromosome, complete genome	blastn	477	124	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma feriruminatoris
6116463	6116463	PRJNA1067370_P_NODE_76225_length_255_cov_1.928571_g75676_i0	PRJNA1067370	76225	255	1.928571	4.91785605	Mycoplasmopsis	2767358	Bacteria	Bacteria	472	1.5e-128	NTclustered	gi\|1874468068\|gb\|CP058969.1\|	28903	g75676	i0	100	140.094117647059	255	0	100	0	1	255	229708	229962	Mycoplasmopsis bovis strain 1982-M6152 chromosome	blastn	35724	472	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
13766563	13766563	PRJNA1067370_P_NODE_33051_length_343_cov_1.148148_g32503_i0	PRJNA1067370	33051	343	1.148148	3.93814764	Mycoplasma	2093	Bacteria	Bacteria	628	1.1799999999999997e-175	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g32503	i0	99.708	193.985422740525	343	1	100	0	1	343	270258	269916	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	66537	628	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
15040836	15040836	PRJNA1067370_P_NODE_103972_length_244_cov_0.900585_g103423_i0	PRJNA1067370	103972	244	0.900585	2.1974274	Mesomycoplasma	2923352	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g103423	i0	100	16.5204918032787	244	0	100	0	1	244	511560	511803	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4031	451	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
15040999	15040999	PRJNA1067370_P_NODE_79652_length_251_cov_0.865169_g79103_i0	PRJNA1067370	79652	251	0.865169	2.17157419	Mesomycoplasma	2923352	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g79103	i0	100	15	251	0	100	0	1	251	253162	253412	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3765	464	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16315798	16315798	PRJNA1067370_P_NODE_99593_length_245_cov_0.895349_g99044_i0	PRJNA1067370	99593	245	0.895349	2.19360505	Mesomycoplasma	2923352	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g99044	i0	100	216.318367346939	245	0	100	0	1	245	303163	303407	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	52998	453	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16757984	16757984	PRJNA1067370_P_NODE_73534_length_259_cov_1.741935_g72985_i0	PRJNA1067370	73534	259	1.741935	4.51161165	Mycoplasmopsis gallopavonis	76629	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1563802541\|emb\|LR215032.1\|	76629	g72985	i0	94.286	0.135135135135135	35	1	14	1	78	112	261010	261043	Mycoplasma gallopavonis strain NCTC10186 genome assembly, plasmid: 2	blastn	35	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis gallopavonis
17590954	17590954	PRJNA1067370_P_NODE_115874_length_239_cov_2.060241_g115325_i0	PRJNA1067370	115874	239	2.060241	4.92397599	Mycoplasmopsis	2767358	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|1874468068\|gb\|CP058969.1\|	28903	g115325	i0	100	98.7615062761506	239	0	100	0	1	239	544261	544023	Mycoplasmopsis bovis strain 1982-M6152 chromosome	blastn	23604	442	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
17591127	17591127	PRJNA1067370_P_NODE_90874_length_248_cov_0.880000_g90325_i0	PRJNA1067370	90874	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|365822471\|gb\|JN935874.1\|	51364	g90325	i0	100	159.004032258065	248	0	100	0	1	248	941	1188	Mycoplasma cottewii strain VIS 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39433	459	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
21857928	21857928	PRJNA1067370_P_NODE_82058_length_250_cov_3.112994_g81509_i0	PRJNA1067370	82058	250	3.112994	7.782485	Mycoplasma capricolum	2095	Bacteria	Bacteria	183	7.7e-42	NTclustered	gi\|1822115085\|gb\|CP041700.1\|	40480	g81509	i0	83.085	36.996	201	34	80	0	14	214	968085	968285	Mycoplasma capricolum subsp. capripneumoniae strain 05021 chromosome, complete genome	blastn	9249	183	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma capricolum
23965693	23965693	PRJNA1067370_P_NODE_61499_length_277_cov_2.441176_g60950_i0	PRJNA1067370	61499	277	2.441176	6.76205752	Mycoplasmopsis	2767358	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|1874468068\|gb\|CP058969.1\|	28903	g60950	i0	100	100.12274368231	277	0	100	0	1	277	555170	555446	Mycoplasmopsis bovis strain 1982-M6152 chromosome	blastn	27734	512	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
23965737	23965737	PRJNA1067370_P_NODE_84059_length_250_cov_0.870056_g83510_i0	PRJNA1067370	84059	250	0.870056	2.17514	Mycoplasmopsis	2767358	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2111402438\|gb\|CP068733.1\|	28903	g83510	i0	100	101	250	0	100	0	1	250	365922	366171	Mycoplasmopsis bovis strain J81 chromosome, complete genome	blastn	25250	462	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
24406432	24406432	PRJNA1067370_P_NODE_102620_length_244_cov_1.350877_g102071_i0	PRJNA1067370	102620	244	1.350877	3.29613988	Mycoplasmopsis citelli	171281	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1563803758\|emb\|LR215036.1\|	171281	g102071	i0	100	0.237704918032787	29	0	12	0	165	193	524176	524148	Mycoplasma citelli strain NCTC10181 genome assembly, chromosome: 1	blastn	58	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis citelli

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