metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax

4 rows where analysis = "blastn", bioproject = "PRJEB11748" 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
3844882	3844882	PRJEB11748_P_NODE_355744_length_195_cov_2.201493_g353561_i0	PRJEB11748	355744	195	2.201493	4.29291135	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	128	2.72e-25	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g353561	i0	80.347	1.62564102564103	173	31	88	3	1	171	741445	741616	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	317	128	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
3846649	3846649	PRJEB11748_P_NODE_91424_length_438_cov_1.724138_g89256_i0	PRJEB11748	91424	438	1.724138	7.55172444	Spiroplasma endosymbiont of Aspidapion aeneum	3066276	Bacteria	Bacteria	52.8	0.042	NTclustered	gi\|2719904881\|emb\|OZ034994.1\|	3066276	g89256	i0	96.875	0.0730593607305936	32	0	7	1	390	420	557463	557432	Spiroplasma endosymbiont of Aspidapion aeneum isolate 54746 genome assembly, chromosome: 1	blastn	32	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Aspidapion aeneum
19141083	19141083	PRJEB11748_P_NODE_184776_length_297_cov_6.127119_g182593_i0	PRJEB11748	184776	297	6.127119	18.19754343	Mycoplasma incognitus	2101	Bacteria	Bacteria	484	2.3e-132	NTclustered	gi\|150152\|gb\|M58403.1\|MYCIS	2101	g182593	i0	98.551	52.1077441077441	276	1	92	3	1	274	1721	1447	Mycoplasma incognitus insertion sequence unknown genes	blastn	15476	484	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma incognitus
22966323	22966323	PRJEB11748_P_NODE_12879_length_1321_cov_6.968254_g11717_i0	PRJEB11748	12879	1321	6.968254	92.05063534	Spiroplasma endosymbiont of Harpalus anxius	3077931	Bacteria	Bacteria	571	8.389999999999997e-158	NTclustered	gi\|2813305944\|emb\|OZ187007.1\|	3077931	g11717	i0	95.355	145.277062831188	366	5	56	6	142	503	751656	752013	Spiroplasma endosymbiont of Harpalus anxius isolate 66129c39-b7a8-4b37-864c-2d57ae6f9329 genome assembly, chromosome: 1	blastn	191911	571	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Harpalus anxius

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