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

5 rows where bioproject = "PRJNA263496" 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
369366	369366	PRJNA263496_P_NODE_24361_length_163_cov_0.894737_g24108_i0	PRJNA263496	24361	163	0.894737	1.45842131	Macrochaete psychrophila	1844959	Bacteria	Bacteria	287	3.42e-73	NTclustered	gi\|1026261016\|gb\|KT336439.2\|	1781141	g24108	i0	98.182	296.920245398773	165	1	100	1	1	163	2302	2138	Macrochaete psychrophila CCALA 32 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48398	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete psychrophila
2332487	2332487	PRJNA263496_P_NODE_5582_length_350_cov_1.435216_g5329_i0	PRJNA263496	5582	350	1.435216	5.023256	Bacteria	2	Bacteria	Bacteria	647	0	NTclustered	gi\|199584200\|gb\|FJ028692.1\|	1211	g5329	i0	100	99.9714285714286	350	0	100	0	1	350	712	363	Uncultured cyanobacterium clone SSB-70 16S ribosomal RNA gene, partial sequence	blastn	34990	647	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6747387	6747387	PRJNA263496_P_NODE_9866_length_251_cov_2.841584_g9613_i0	PRJNA263496	9866	251	2.841584	7.13237584	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	300	7.36e-77	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g9613	i0	88.4	167.824701195219	250	27	99	2	1	249	2919	3167	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	42124	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
27737731	27737731	PRJNA263496_P_NODE_24684_length_162_cov_0.902655_g24431_i0	PRJNA263496	24684	162	0.902655	1.4623011	Aliterella atlantica	1827278	Bacteria	Bacteria	106	2.4400000000000003e-27	NR	WP_045052680.1	1827278	g24431	i0	94.3	2.94444444444444	53	3	98.1	0	160	2	42	94	WP_045052680.1 orange carotenoid protein N-terminal domain-containing protein [Aliterella atlantica]	diamond	477	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
32823684	32823684	PRJNA263496_P_NODE_13640_length_212_cov_0.938650_g13387_i0	PRJNA263496	13640	212	0.93865	1.989938	Aliterella atlantica	1827278	Bacteria	Bacteria	48.5	2.12e-5	NR	WP_045055378.1	1827278	g13387	i0	100	0.35377358490566	25	0	35.4	0	2	76	53	77	WP_045055378.1 hypothetical protein [Aliterella atlantica]	diamond	75	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica

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