metadata: contig_metadata: 5 rows where bioproject = "PRJNA811237", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA811237", 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
11012710	11012710	PRJNA811237_S_NODE_29849_length_165_cov_1.267241_g29609_i0	PRJNA811237	29849	165	1.267241	2.09094765	Mesomycoplasma ovipneumoniae	29562	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2290352126\|gb\|CP079200.1\|	29562	g29609	i0	100	0.175757575757576	29	0	18	0	35	63	1009149	1009177	Mesomycoplasma ovipneumoniae strain 150 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma ovipneumoniae
27410989	27410989	PRJNA811237_S_NODE_23643_length_177_cov_1.875000_g23403_i0	PRJNA811237	23643	177	1.875	3.31875	Bacillati	1783272	Bacteria	Bacteria	41.6	0.0384	NR	WP_025363498.1	216935	g23403	i0	48.9	1.66101694915254	45	20	72.9	2	46	174	161	204	WP_025363498.1 tRNA pseudouridine(38-40) synthase TruA [Spiroplasma culicicola]	diamond	294	42	0.990476190476191	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma culicicola
28096517	28096517	PRJNA811237_S_NODE_10045_length_242_cov_2.424870_g9805_i0	PRJNA811237	10045	242	2.42487	5.8681854	Candidatus Moeniiplasma glomeromycotorum	1822367	Bacteria	Bacteria	42.7	0.0256	NR	MCE8162780.1	1822367	g9805	i0	32.5	0.954545454545455	77	37	94.2	2	242	15	80	142	MCE8162780.1 hypothetical protein [Candidatus Moeniiplasma glomeromycotorum]	diamond	231	42.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Candidatus Moeniiplasma	Candidatus Moeniiplasma glomeromycotorum
28570082	28570082	PRJNA811237_S_NODE_18427_length_195_cov_1.636986_g18187_i0	PRJNA811237	18427	195	1.636986	3.1921227	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	50.1	5.04e-5	NR	QVK21138.1	2231116	g18187	i0	54.9	0.784615384615385	51	22	78.5	1	184	32	493	542	QVK21138.1 glutamine--tRNA ligase/YqeY domain fusion protein [Mycoplasmatota bacterium]	diamond	153	50.1	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
31444712	31444712	PRJNA811237_S_NODE_36736_length_152_cov_2.524272_g36496_i0	PRJNA811237	36736	152	2.524272	3.83689344	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	58.2	2.67e-8	NR	MDK2819479.1	2685873	g36496	i0	73.5	3.25657894736842	34	9	67.1	0	3	104	89	122	MDK2819479.1 ATP-binding cassette domain-containing protein [Mycoplasmataceae bacterium]	diamond	495	58.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae 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);;