metadata: contig_metadata: 8 rows where bioproject = "PRJNA1066877" and tax

8 rows where bioproject = "PRJNA1066877" 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
180477	180477	PRJNA1066877_S_NODE_8121_length_191_cov_1.598592_g8086_i0	PRJNA1066877	8121	191	1.598592	3.05331072	Aliterellaceae cyanobacterium OD121D	3141615	Bacteria	Bacteria	292	8.89e-75	NTclustered	gi\|2719983750\|gb\|PP708903.1\|	3141615	g8086	i0	96.089	69.7539267015707	179	7	94	0	11	189	1201	1023	Aliterellaceae cyanobacterium OD121D 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	13323	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae		Aliterellaceae cyanobacterium OD121D
4006917	4006917	PRJNA1066877_S_NODE_9044_length_184_cov_0.948148_g9009_i0	PRJNA1066877	9044	184	0.948148	1.74459232	Crinalium epipsammum	241425	Bacteria	Bacteria	86.1	1.55e-12	NTclustered	gi\|428245228\|gb\|CP003620.1\|	1173022	g9009	i0	89.706	0.369565217391304	68	5	36	2	89	155	4138203	4138137	Crinalium epipsammum PCC 9333, complete genome	blastn	68	86.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Crinalium	Crinalium epipsammum
8666301	8666301	PRJNA1066877_S_NODE_8587_length_187_cov_1.963768_g8552_i0	PRJNA1066877	8587	187	1.963768	3.67224616	Cyanophyceae	3028117	Bacteria	Bacteria	171	4.24e-38	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g8552	i0	87.013	19.4171122994652	154	17	82	3	2	154	3673527	3673678	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	3631	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
10383606	10383606	PRJNA1066877_S_NODE_1709_length_343_cov_1.571429_g1674_i0	PRJNA1066877	1709	343	1.571429	5.39000147	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	144	8.12e-41	NR	WP_009631905.1	927677	g1674	i0	100	0.594752186588921	68	0	59.5	0	5	208	50	117	WP_009631905.1 transcription termination/antitermination protein NusG [Synechocystis sp. PCC 7509]	diamond	204	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
15483164	15483164	PRJNA1066877_S_NODE_5093_length_226_cov_1.881356_g5058_i0	PRJNA1066877	5093	226	1.881356	4.25186456	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	180	8.84e-41	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g5058	i0	83.854	54.9646017699115	192	27	84	4	37	226	3197	3008	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	12422	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16757288	16757288	PRJNA1066877_S_NODE_3694_length_255_cov_3.349515_g3659_i0	PRJNA1066877	3694	255	3.349515	8.54126325	Aliterella chasmolithica	2739056	Bacteria	Bacteria	383	7.23e-102	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g3659	i0	93.725	126.294117647059	255	16	100	0	1	255	2223	1969	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	32205	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
23965402	23965402	PRJNA1066877_S_NODE_3579_length_259_cov_1.242857_g3544_i0	PRJNA1066877	3579	259	1.242857	3.21899963	Cyanophyceae	3028117	Bacteria	Bacteria	350	7.47e-92	NTclustered	gi\|146141982\|gb\|EF522486.1\|	1211	g3544	i0	99.479	74.2084942084942	192	1	74	0	68	259	747	556	Uncultured cyanobacterium clone OCSS038 16S ribosomal RNA gene, partial sequence	blastn	19220	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26623903	26623903	PRJNA1066877_S_NODE_9541_length_180_cov_1.167939_g9506_i0	PRJNA1066877	9541	180	1.167939	2.1022902	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	111	4.27e-28	NR	WP_106367893.1	2107693	g9506	i0	88.1	2.95	59	7	98.3	0	2	178	103	161	WP_106367893.1 4-hydroxy-tetrahydrodipicolinate synthase [Chlorogloea sp. CCALA 695]	diamond	531	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695

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