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

5 rows where bioproject = "PRJNA1108009", 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
2295934	2295934	PRJNA1108009_P_NODE_19722_length_290_cov_0.990783_g19404_i0	PRJNA1108009	19722	290	0.990783	2.8732707	Mollicutes	31969	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1563683120\|emb\|LR214951.1\|	2120	g19404	i0	100	0.306896551724138	29	0	10	0	161	189	408784	408812	Mycoplasma neurolyticum strain NCTC10166 genome assembly, chromosome: 1	blastn	89	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma neurolyticum
7865980	7865980	PRJNA1108009_P_NODE_31807_length_241_cov_0.916667_g31489_i0	PRJNA1108009	31807	241	0.916667	2.20916747	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	255	1.54e-63	NTclustered	gi\|2187152065\|emb\|OV788643.1\|	658143	g31489	i0	87.111	99.0331950207469	225	29	93	0	16	240	833666	833442	uncultured Tenericutes bacterium isolate min17_bin32 genome assembly, chromosome: 1	blastn	23867	255	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
10416641	10416641	PRJNA1108009_P_NODE_31869_length_241_cov_0.886905_g31551_i0	PRJNA1108009	31869	241	0.886905	2.13744105	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	230	9.34e-56	NTclustered	gi\|2187152065\|emb\|OV788643.1\|	658143	g31551	i0	84.167	20.1784232365145	240	34	99	3	4	241	685378	685141	uncultured Tenericutes bacterium isolate min17_bin32 genome assembly, chromosome: 1	blastn	4863	230	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
31363442	31363442	PRJNA1108009_P_NODE_11696_length_391_cov_3.276730_g11378_i0	PRJNA1108009	11696	391	3.27673	12.8120143	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	125	1.19e-33	NR	MBW0597145.1	171279	g11378	i0	71.1	0.744245524296675	97	28	74.4	0	317	27	62	158	MBW0597145.1 hypothetical protein [Mycoplasmopsis anatis]	diamond	291	125	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis
32344250	32344250	PRJNA1108009_P_NODE_31479_length_241_cov_0.916667_g31161_i0	PRJNA1108009	31479	241	0.916667	2.20916747	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	105	3.57e-24	NR	MCI5939729.1	1898209	g31161	i0	67.1	2.95020746887967	79	26	98.3	0	239	3	228	306	MCI5939729.1 ATP-binding cassette domain-containing protein [Acholeplasmataceae bacterium]	diamond	711	105	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae 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);;