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

13 rows where analysis = "blastn", bioproject = "PRJNA782235" 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
763324	763324	PRJNA782235_P_NODE_21101_length_247_cov_0.885057_g20912_i0	PRJNA782235	21101	247	0.885057	2.18609079	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	394	3.22e-105	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g20912	i0	96.639	1.92712550607287	238	7	96	1	10	247	6142517	6142753	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	476	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
3764022	3764022	PRJNA782235_P_NODE_16763_length_251_cov_0.865169_g16574_i0	PRJNA782235	16763	251	0.865169	2.17157419	Chroococcidiopsis	54298	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g16574	i0	99.602	2	251	1	100	0	1	251	2351035	2350785	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	502	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
3764113	3764113	PRJNA782235_P_NODE_7123_length_334_cov_0.885057_g6934_i0	PRJNA782235	7123	334	0.885057	2.95609038	Cyanophyceae	3028117	Bacteria	Bacteria	457	5.7099999999999996e-124	NTclustered	gi\|2591945363\|gb\|CP053586.1\|	2547451	g6934	i0	91.395	100.634730538922	337	23	100	6	1	334	449884	450217	Leptolyngbya sp. NK1-12 chromosome 1, complete sequence	blastn	33612	459	0.995642701525055	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
4591814	4591814	PRJNA782235_P_NODE_6924_length_338_cov_1.094340_g6735_i0	PRJNA782235	6924	338	1.09434	3.6988692	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	542	1.55e-149	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g6735	i0	96.923	110.934911242604	325	6	95	3	17	338	2220	2543	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	37496	542	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5866805	5866805	PRJNA782235_P_NODE_19245_length_249_cov_0.875000_g19056_i0	PRJNA782235	19245	249	0.875	2.17875	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g19056	i0	99.197	145.622489959839	249	2	100	0	1	249	3569	3321	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36260	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
9691610	9691610	PRJNA782235_P_NODE_12108_length_276_cov_1.137931_g11919_i0	PRJNA782235	12108	276	1.137931	3.14068956	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g11919	i0	100	102.489130434783	276	0	100	0	1	276	4386	4111	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28287	510	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
10967507	10967507	PRJNA782235_P_NODE_23449_length_245_cov_0.895349_g23260_i0	PRJNA782235	23449	245	0.895349	2.19360505	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	359	1.16e-94	NTclustered	gi\|2245130261\|gb\|CP097481.1\|	2653189	g23260	i0	93.061	2	245	17	100	0	1	245	204995	204751	Chroococcidiopsis sp. CCNUC1 plasmid pA, complete sequence	blastn	490	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
10967537	10967537	PRJNA782235_P_NODE_26109_length_243_cov_0.905882_g25920_i0	PRJNA782235	26109	243	0.905882	2.20129326	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	244	3.37e-60	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g25920	i0	84.836	280.600823045267	244	36	100	1	1	243	597988	598231	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	68186	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12243011	12243011	PRJNA782235_P_NODE_25950_length_243_cov_0.905882_g25761_i0	PRJNA782235	25950	243	0.905882	2.20129326	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g25761	i0	100	0.11522633744856	28	0	12	0	161	188	1687046	1687073	Synechococcus sp. CB0101 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
13517080	13517080	PRJNA782235_P_NODE_15991_length_252_cov_1.290503_g15802_i0	PRJNA782235	15991	252	1.290503	3.25206756	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	398	2.5499999999999997e-106	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g15802	i0	95.238	173.333333333333	252	11	100	1	1	252	3669621	3669871	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	43680	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
14792029	14792029	PRJNA782235_P_NODE_27992_length_241_cov_0.916667_g27803_i0	PRJNA782235	27992	241	0.916667	2.20916747	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g27803	i0	100	2	241	0	100	0	1	241	6175314	6175074	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	482	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
16065696	16065696	PRJNA782235_P_NODE_13873_length_265_cov_1.312500_g13684_i0	PRJNA782235	13873	265	1.3125	3.478125	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	468	2.03e-127	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g13684	i0	98.855	277.11320754717	262	3	99	0	4	265	2332	2071	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	73435	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
20338715	20338715	PRJNA782235_P_NODE_11436_length_280_cov_1.473430_g11247_i0	PRJNA782235	11436	280	1.47343	4.125604	Chroococcidiopsis	54298	Bacteria	Bacteria	472	1.6699999999999998e-128	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g11247	i0	97.464	163.721428571429	276	7	99	0	5	280	3101	2826	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	45842	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025

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