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

9 rows where analysis = "blastn", bioproject = "PRJNA690124" 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
3220312	3220312	PRJNA690124_P_NODE_41263_length_258_cov_2.951351_g40897_i0	PRJNA690124	41263	258	2.951351	7.61448558	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	416	7.229999999999998e-112	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g40897	i0	95.736	162.895348837209	258	11	100	0	1	258	3670328	3670585	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	42027	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
8322773	8322773	PRJNA690124_P_NODE_5127_length_701_cov_2.730892_g4780_i0	PRJNA690124	5127	701	2.730892	19.14355292	Nodosilinea sp. 2.2B	2876719	Bacteria	Bacteria	1229	0	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g4780	i0	98.288	168.666191155492	701	12	100	0	1	701	2647	1947	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	118235	1229	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
8322915	8322915	PRJNA690124_P_NODE_57307_length_211_cov_4.202899_g56941_i0	PRJNA690124	57307	211	4.202899	8.86811689	Nodosilinea sp. 2.2B	2876719	Bacteria	Bacteria	390	3.459999999999999e-104	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g56941	i0	100	157.284360189573	211	0	100	0	1	211	3493	3703	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33187	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
11381721	11381721	PRJNA690124_P_NODE_17509_length_387_cov_1.442675_g17143_i0	PRJNA690124	17509	387	1.442675	5.58315225	Pleurocapsales	52604	Bacteria	Bacteria	671	0	NTclustered	gi\|2075441650\|ref\|NR_172667.1\|	54308	g17143	i0	97.938	101.049095607235	388	7	100	1	1	387	486	873	Pleurocapsa minor strain HA4230-MV1 16S ribosomal RNA, complete sequence	blastn	39106	671	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa minor
13932452	13932452	PRJNA690124_P_NODE_32871_length_289_cov_1.759259_g32505_i0	PRJNA690124	32871	289	1.759259	5.08425851	root	1	Root_unresolved	Root_unresolved	126	1.5499999999999998e-24	NTclustered	gi\|311115847\|gb\|HQ329074.1\|	1211	g32505	i0	100	23.757785467128	68	0	24	0	222	289	494	427	Uncultured cyanobacterium clone LvLM1.2.16 16S ribosomal RNA gene, partial sequence	blastn	6866	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14697923	14697923	PRJNA690124_P_NODE_20432_length_359_cov_2.248252_g20066_i0	PRJNA690124	20432	359	2.248252	8.07122468	Aliterella chasmolithica	2739056	Bacteria	Bacteria	525	1.6699999999999996e-144	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g20066	i0	94.925	173.779944289694	335	17	93	0	25	359	2500	2166	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	62387	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
14698735	14698735	PRJNA690124_P_NODE_6412_length_632_cov_1.844365_g6053_i0	PRJNA690124	6412	632	1.844365	11.6563868	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	1040	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g6053	i0	96.378	178.773734177215	635	17	100	4	1	632	3669604	3670235	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	112985	1040	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
21580781	21580781	PRJNA690124_P_NODE_4377_length_754_cov_4.483113_g4046_i0	PRJNA690124	4377	754	4.483113	33.80267202	Nodosilinea	1120752	Bacteria	Bacteria	1382	0	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g4046	i0	99.735	153.781167108753	754	2	100	0	1	754	2625	3378	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	115951	1382	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
25405025	25405025	PRJNA690124_P_NODE_37620_length_271_cov_1.575758_g37254_i0	PRJNA690124	37620	271	1.575758	4.27030418	Nostoc	1177	Bacteria	Bacteria	353	6.08e-93	NTclustered	gi\|930349143\|gb\|CP012036.1\|	224013	g37254	i0	90.406	231.752767527675	271	23	99	3	1	270	379918	379650	Nostoc piscinale CENA21 chromosome	blastn	62805	355	0.994366197183099	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc piscinale

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