metadata: contig_metadata: 7 rows where bioproject = "PRJNA781427", tax_kingdom = "Bacillati" and tax

7 rows where bioproject = "PRJNA781427", 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	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
2037609	2037609	PRJNA781427_P_NODE_77802_length_250_cov_0.870056_g76918_i0	PRJNA781427	77802	250	0.870056	2.17514	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2785563086\|gb\|CP165990.1\|	2094	g76918	i0	96.97	0.132	33	0	13	1	93	125	601027	600996	Mycoplasmopsis arginini strain LGL1 chromosome, complete genome	blastn	33	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
2487499	2487499	PRJNA781427_P_NODE_75502_length_251_cov_0.865169_g74618_i0	PRJNA781427	75502	251	0.865169	2.17157419	Candidatus Phytoplasma australasiaticum	2754999	Bacteria	Bacteria	132	2.7799999999999997e-37	NR	MDV3194623.1	2754999	g74618	i0	89.9	18.9203187250996	69	7	82.5	0	208	2	47	115	MDV3194623.1 reverse transcriptase family protein [Candidatus Phytoplasma australasiaticum]	diamond	4749	132	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum
10964802	10964802	PRJNA781427_P_NODE_42969_length_347_cov_1.178832_g42087_i0	PRJNA781427	42969	347	1.178832	4.09054704	Malacoplasma microti	38746	Bacteria	Bacteria	390	6.13e-104	NTclustered	gi\|299851939\|gb\|HM135466.1\|	38746	g42087	i0	87.179	146.533141210375	351	36	100	7	1	347	1573	1228	Mycoplasma microti strain IL371 23S ribosomal RNA gene, partial sequence	blastn	50847	390	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma microti
22437454	22437454	PRJNA781427_P_NODE_22238_length_509_cov_1.256881_g21362_i0	PRJNA781427	22238	509	1.256881	6.39752429	Mycoplasmopsis cynos	171284	Bacteria	Bacteria	52.8	0.05	NTclustered	gi\|2639809411\|gb\|CP141046.1\|	171284	g21362	i0	100	0.385068762278978	28	0	6	0	481	508	531868	531841	Mycoplasmopsis cynos strain 30510 chromosome	blastn	196	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis cynos
29011852	29011852	PRJNA781427_P_NODE_74428_length_251_cov_0.865169_g73544_i0	PRJNA781427	74428	251	0.865169	2.17157419	Candidatus Phytoplasma australasiaticum	2754999	Bacteria	Bacteria	124	5.42e-34	NR	MDV3194640.1	2754999	g73544	i0	90.5	0.752988047808765	63	6	75.3	0	63	251	70	132	MDV3194640.1 hypothetical protein [Candidatus Phytoplasma australasiaticum]	diamond	189	124	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum
30062789	30062789	PRJNA781427_P_NODE_86091_length_246_cov_0.890173_g85207_i0	PRJNA781427	86091	246	0.890173	2.18982558	Candidatus Izemoplasma	2975549	Bacteria	Bacteria	84.7	2.06e-17	NR	AIO19034.1	1541959	g85207	i0	72.2	3.23170731707317	54	15	65.9	0	245	84	249	302	AIO19034.1 Pseudouridine-5'-phosphate glycosidase [Candidatus Izimaplasma bacterium HR1]	diamond	795	84.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Candidatus Izemoplasmataceae	Candidatus Izemoplasma	Candidatus Izimoplasma sp. HR1
31760316	31760316	PRJNA781427_P_NODE_94537_length_242_cov_0.911243_g93653_i0	PRJNA781427	94537	242	0.911243	2.20520806	Candidatus Phytoplasma australasiaticum	2754999	Bacteria	Bacteria	92	4.09e-21	NR	MDV3194616.1	2754999	g93653	i0	67.2	0.793388429752066	64	21	79.3	0	51	242	35	98	MDV3194616.1 hypothetical protein [Candidatus Phytoplasma australasiaticum]	diamond	192	92	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australasiaticum

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