metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA681861" and tax_clade = "Cyanobacteriota/Melainabacteria group"

12 rows where analysis = "blastn", bioproject = "PRJNA681861" 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
657425	657425	PRJNA681861_P_NODE_23701_length_269_cov_21.958333_g21601_i0	PRJNA681861	23701	269	21.958333	59.06791577	Aliterella chasmolithica	2739056	Bacteria	Bacteria	392	1.28e-104	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g21601	i0	93.536	122.074349442379	263	17	98	0	7	269	2225	1963	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	32838	392	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
3208392	3208392	PRJNA681861_P_NODE_45123_length_160_cov_3.732824_g43023_i0	PRJNA681861	45123	160	3.732824	5.9725184	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	222	9.559999999999999e-54	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g43023	i0	92.357	150.76875	157	11	98	1	5	160	3669362	3669518	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	24123	222	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
3723163	3723163	PRJNA681861_P_NODE_9603_length_615_cov_49.940273_g7757_i0	PRJNA681861	9603	615	49.940273	307.13267895	Leptolyngbya	47251	Bacteria	Bacteria	889	0	NTclustered	gi\|46409901\|gb\|AY584526.1\|	272134	g7757	i0	92.718	146.583739837398	618	41	100	4	1	615	1323	707	Leptolyngbya boryana PCC 6306 23S ribosomal RNA gene, partial sequence	blastn	90149	894	0.994407158836689	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
4485512	4485512	PRJNA681861_P_NODE_14444_length_427_cov_7.678392_g12374_i0	PRJNA681861	14444	427	7.678392	32.78673384	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	468	3.45e-127	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g12374	i0	95.318	114.088992974239	299	6	95	7	1	291	2089	1791	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48716	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4485514	4485514	PRJNA681861_P_NODE_14744_length_419_cov_8.100000_g12670_i0	PRJNA681861	14744	419	8.1	33.939	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	370	9.8e-98	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g12670	i0	96.491	151.801909307876	228	1	98	6	1	221	2089	1862	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	63605	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9586011	9586011	PRJNA681861_P_NODE_14108_length_436_cov_9.257985_g12053_i0	PRJNA681861	14108	436	9.257985	40.3648146	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	370	1.02e-97	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g12053	i0	96.491	82.7981651376147	228	1	51	6	1	221	2089	1862	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36100	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11374990	11374990	PRJNA681861_P_NODE_16989_length_369_cov_134.273529_g14893_i0	PRJNA681861	16989	369	134.273529	495.46932201	Tolypothrichaceae	119859	Bacteria	Bacteria	544	4.7499999999999984e-150	NTclustered	gi\|55418271\|gb\|AY642577.1\|	1211	g14893	i0	93.243	100.279132791328	370	23	100	2	1	369	401	769	Uncultured cyanobacterium clone LV60-CY1-1 16S ribosomal RNA gene, partial sequence	blastn	37003	547	0.994515539305302	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15199979	15199979	PRJNA681861_P_NODE_7692_length_735_cov_181.298867_g6057_i0	PRJNA681861	7692	735	181.298867	1332.54667245	Cyanophyceae	3028117	Bacteria	Bacteria	965	0	NTclustered	gi\|46409895\|gb\|AY584520.1\|	212450	g6057	i0	90.723	159.518367346939	733	55	99	11	1	729	764	41	Leptolyngbya sp. PCC 7410 23S ribosomal RNA gene, partial sequence	blastn	117246	972	0.992798353909465	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 7410
16474179	16474179	PRJNA681861_P_NODE_37353_length_182_cov_68.751634_g35253_i0	PRJNA681861	37353	182	68.751634	125.12797388	Cyanophyceae	3028117	Bacteria	Bacteria	329	6.39e-86	NTclustered	gi\|105990319\|gb\|DQ514050.1\|	1211	g35253	i0	99.448	99.1978021978022	181	1	99	0	1	181	840	660	Uncultured cyanobacterium clone 100M2_B9 16S ribosomal RNA gene, partial sequence	blastn	18054	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16474190	16474190	PRJNA681861_P_NODE_6473_length_848_cov_24.692308_g5002_i0	PRJNA681861	6473	848	24.692308	209.39077184	Leptolyngbya	47251	Bacteria	Bacteria	1009	0	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g5002	i0	88.475	210.035377358491	859	67	99	25	5	847	246833	247675	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	178110	1009	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
17749184	17749184	PRJNA681861_P_NODE_19614_length_322_cov_16.218430_g17514_i0	PRJNA681861	19614	322	16.21843	52.2233446	Leptolyngbya	47251	Bacteria	Bacteria	427	4.299999999999999e-115	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g17514	i0	92.079	128.208074534161	303	24	95	0	16	318	247135	246833	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	41283	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
23610476	23610476	PRJNA681861_P_NODE_36639_length_185_cov_6.070513_g34539_i0	PRJNA681861	36639	185	6.070513	11.23044905	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g34539	i0	100	146.378378378378	185	0	100	0	1	185	3080	2896	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27080	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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