metadata: contig_metadata: 6 rows where bioproject = "PRJEB12366" and tax

6 rows where bioproject = "PRJEB12366" and tax_phylum = "Cyanobacteriota"

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
6398944	6398944	PRJEB12366_S_NODE_4066_length_153_cov_11.991525_g4058_i0	PRJEB12366	4066	153	11.991525	18.34703325	Aliterella chasmolithica	2739056	Bacteria	Bacteria	255	8.900000000000001e-64	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g4058	i0	96.732	126.803921568627	153	5	100	0	1	153	2119	1967	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	19401	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
16597540	16597540	PRJEB12366_P_NODE_12994_length_202_cov_1.089820_g12804_i0	PRJEB12366	12994	202	1.08982	2.2014364	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	309	9.45e-80	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g12804	i0	94.5	136.138613861386	200	11	99	0	3	202	3205	3006	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27500	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16597545	16597545	PRJEB12366_P_NODE_13754_length_194_cov_1.509434_g13564_i0	PRJEB12366	13754	194	1.509434	2.92830196	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	318	1.5e-82	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g13564	i0	96.373	202.618556701031	193	7	99	0	2	194	1783	1591	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39308	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19146318	19146318	PRJEB12366_S_NODE_2556_length_171_cov_2.316176_g2548_i0	PRJEB12366	2556	171	2.316176	3.96066096	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	211	2.23e-50	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g2548	i0	92.053	37.8245614035088	151	11	88	1	1	150	2490	2340	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	6468	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
24246599	24246599	PRJEB12366_P_NODE_6640_length_311_cov_3.173913_g6450_i0	PRJEB12366	6640	311	3.173913	9.87086943	Annamia dubia	2815909	Bacteria	Bacteria	104	7.91e-18	NTclustered	gi\|2663421582\|dbj\|AP025630.1\|	2759045	g6450	i0	76.699	7.5016077170418	206	36	64	10	4	203	2054606	2054805	Annamia dubia NIES-4383 DNA, complete genome	blastn	2333	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Annamia	Annamia dubia
29938344	29938344	PRJEB12366_P_NODE_13911_length_193_cov_1.012658_g13721_i0	PRJEB12366	13911	193	1.012658	1.95442994	Planktothrix sp. FACHB-1355	2692854	Bacteria	Bacteria	114	1.4e-31	NR	WP_191055919.1	2692854	g13721	i0	84.2	1.78756476683938	57	9	88.6	0	2	172	15	71	WP_191055919.1 MbtH family protein [Planktothrix sp. FACHB-1355]	diamond	345	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp. FACHB-1355

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