metadata: contig_metadata: 5 rows where bioproject = "PRJNA635397" and tax_clade = "Cyanobacteriota/Melainabacteria group"

5 rows where bioproject = "PRJNA635397" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
12085493	12085493	PRJNA635397_P_NODE_6730_length_713_cov_2.917187_g6299_i0	PRJNA635397	6730	713	2.917187	20.79954331	Stanieria cyanosphaera	102116	Bacteria	Bacteria	309	3.8300000000000005e-79	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g6299	i0	79.905	20.7980364656381	423	83	59	2	292	713	885	464	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	14829	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
26700938	26700938	PRJNA635397_P_NODE_2881_length_1178_cov_3.491403_g2605_i0	PRJNA635397	2881	1178	3.491403	41.12872734	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	468	3.9999999999999983e-162	NR	MBX9694561.1	2847862	g2605	i0	74.4	2.46010186757216	308	74	77.2	2	1133	225	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2898	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27554638	27554638	PRJNA635397_P_NODE_46504_length_242_cov_0.923077_g46050_i0	PRJNA635397	46504	242	0.923077	2.23384634	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	160	8.55e-44	NR	MCA0314321.1	2052166	g46050	i0	100	0.991735537190083	80	0	99.2	0	3	242	130	209	MCA0314321.1 SH3 domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	240	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29165407	29165407	PRJNA635397_P_NODE_34269_length_270_cov_3.817259_g33815_i0	PRJNA635397	34269	270	3.817259	10.3065993	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	87	8.64e-20	NR	MBX9692690.1	2847862	g33815	i0	64.1	0.711111111111111	64	23	71.1	0	79	270	1	64	MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium]	diamond	192	87	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31724379	31724379	PRJNA635397_P_NODE_45577_length_243_cov_1.188235_g45123_i0	PRJNA635397	45577	243	1.188235	2.88741105	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	43.1	0.0142	NR	HEY9807325.1	2364082	g45123	i0	39.1	1.1358024691358	46	28	56.8	0	141	4	11	56	HEY9807325.1 DUF1963 domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	276	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;