metadata: contig_metadata: 10 rows where bioproject = "PRJNA657343", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA657343", tax_kingdom = "Bacillati" 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	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
3712146	3712146	PRJNA657343_P_NODE_42243_length_163_cov_3.368421_g42219_i0	PRJNA657343	42243	163	3.368421	5.49052623	Mesomycoplasma	2923352	Bacteria	Bacteria	294	2.04e-75	NTclustered	gi\|1958638472\|gb\|MW498281.1\|	2100	g42219	i0	100	97.1533742331288	159	0	98	1	159	2177	2335	Mesomycoplasma hyorhinis strain MycSu21 23S ribosomal RNA gene, partial sequence	blastn	15836	294	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
7538323	7538323	PRJNA657343_P_NODE_6486_length_314_cov_4.901887_g6462_i0	PRJNA657343	6486	314	4.901887	15.39192518	Mycoplasma	2093	Bacteria	Bacteria	512	1.12e-140	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g6462	i0	99.293	179.050955414013	283	2	90	32	314	271978	271696	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	56222	512	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
10089023	10089023	PRJNA657343_P_NODE_47228_length_153_cov_2.951923_g47204_i0	PRJNA657343	47228	153	2.951923	4.51644219	Metamycoplasmataceae	2895623	Bacteria	Bacteria	276	6.83e-70	NTclustered	gi\|23451293\|gb\|AF422142.1\|	2115	g47204	i0	100	187.535947712418	149	0	97	2	150	449	597	Mycoplasma fermentans 23S ribosomal RNA gene, domains IV and V, partial sequence	blastn	28693	276	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis fermentans
15188919	15188919	PRJNA657343_P_NODE_19432_length_209_cov_5.537500_g19408_i0	PRJNA657343	19432	209	5.5375	11.573375	Mycoplasma	2093	Bacteria	Bacteria	368	1.5999999999999996e-97	NTclustered	gi\|54609775\|gb\|AY765214.1\|	51364	g19408	i0	99.024	182.44019138756	205	2	98	3	207	442	646	Mycoplasma cottewii strain ATCC 43093 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	38130	368	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
16463183	16463183	PRJNA657343_P_NODE_19953_length_207_cov_5.753165_g19929_i0	PRJNA657343	19953	207	5.753165	11.90905155	Mollicutes	31969	Bacteria	Bacteria	372	1.2199999999999997e-98	NTclustered	gi\|1958638505\|gb\|MW498314.1\|	2100	g19929	i0	99.51	98.5507246376812	204	1	99	4	207	2673	2876	Mesomycoplasma hyorhinis strain MycSu128 23S ribosomal RNA gene, partial sequence	blastn	20400	372	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16463185	16463185	PRJNA657343_P_NODE_21473_length_202_cov_1.326797_g21449_i0	PRJNA657343	21473	202	1.326797	2.68012994	Metamycoplasmataceae	2895623	Bacteria	Bacteria	364	1.99e-96	NTclustered	gi\|507148354\|ref\|NR_103157.1\|	2115	g21449	i0	99.5	169.727722772277	200	1	99	2	201	81	280	Mycoplasma fermentans strain JER 23S ribosomal RNA gene, complete sequence	blastn	34285	364	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis fermentans
16463211	16463211	PRJNA657343_P_NODE_45613_length_159_cov_2.227273_g45589_i0	PRJNA657343	45613	159	2.227273	3.54136407	Mycoplasma	2093	Bacteria	Bacteria	274	2.58e-69	NTclustered	gi\|54609775\|gb\|AY765214.1\|	51364	g45589	i0	98.089	182.396226415094	157	3	99	3	159	853	697	Mycoplasma cottewii strain ATCC 43093 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29001	276	0.992753623188406	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
21562378	21562378	PRJNA657343_P_NODE_11557_length_254_cov_2.643902_g11533_i0	PRJNA657343	11557	254	2.643902	6.71551108	Mollicutes	31969	Bacteria	Bacteria	448	2.5199999999999996e-121	NTclustered	gi\|281186773\|gb\|GU227378.1\|	2100	g11533	i0	99.194	101.354330708661	248	2	98	4	251	1112	1359	Mycoplasma hyorhinis strain USP36P 16S ribosomal RNA gene, partial sequence	blastn	25744	448	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
22837841	22837841	PRJNA657343_P_NODE_4678_length_354_cov_7.888525_g4655_i0	PRJNA657343	4678	354	7.888525	27.9253785	Mycoplasma	2093	Bacteria	Bacteria	643	4.3399999999999985e-180	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g4655	i0	100	190.71186440678	348	0	98	7	354	270206	269859	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	67512	643	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
22837844	22837844	PRJNA657343_P_NODE_8618_length_283_cov_8.914530_g8594_i0	PRJNA657343	8618	283	8.91453	25.2281199	Mollicutes	31969	Bacteria	Bacteria	494	3.61e-135	NTclustered	gi\|281186802\|gb\|GU227407.1\|	2099	g8594	i0	99.63	95.4204946996466	270	1	95	11	280	757	488	Mycoplasma hyopneumoniae strain USP14P 16S ribosomal RNA gene, partial sequence	blastn	27004	494	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyopneumoniae

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