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

13 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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
1467219	1467219	PRJNA1078753_P_NODE_38282_length_244_cov_0.900585_g38086_i0	PRJNA1078753	38282	244	0.900585	2.1974274	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	316	7.069999999999998e-82	NTclustered	gi\|2245450223\|gb\|CP083762.1\|	155894	g38086	i0	90.164	6.4016393442623	244	23	100	1	1	244	198555	198313	Chroococcidiopsis sp. CCMEE 29 plasmid unnamed, complete sequence	blastn	1562	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
2743248	2743248	PRJNA1078753_P_NODE_25883_length_255_cov_1.175824_g25687_i0	PRJNA1078753	25883	255	1.175824	2.9983512	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	4.26e-114	NTclustered	gi\|225696257\|gb\|FJ805924.1\|	259957	g25687	i0	96.498	122.443137254902	257	7	100	1	1	255	3541	3285	Uncultured Chroococcidiopsis sp. clone AS2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31223	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2743417	2743417	PRJNA1078753_P_NODE_6763_length_413_cov_2.029412_g6567_i0	PRJNA1078753	6763	413	2.029412	8.38147156	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	536	8.989999999999998e-148	NTclustered	gi\|225696248\|gb\|FJ805915.1\|	259957	g6567	i0	90.191	113.200968523002	418	31	100	9	1	413	1848	2260	Uncultured Chroococcidiopsis sp. clone A1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	46752	536	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4844933	4844933	PRJNA1078753_P_NODE_17664_length_288_cov_1.432558_g17468_i0	PRJNA1078753	17664	288	1.432558	4.12576704	Chroococcales	1118	Bacteria	Bacteria	527	3.63e-145	NTclustered	gi\|322504110\|emb\|FR798921.1\|	980450	g17468	i0	99.653	100.059027777778	288	1	100	0	1	288	557	844	Chroococcus sp. 9E-04 partial 16S rRNA gene, strain 9E-04	blastn	28817	532	0.990601503759398	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. 9E-04
4845010	4845010	PRJNA1078753_P_NODE_29824_length_249_cov_1.750000_g29628_i0	PRJNA1078753	29824	249	1.75	4.3575	Nostoc	1177	Bacteria	Bacteria	141	4.68e-29	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g29628	i0	83.226	2.285140562249	155	25	62	1	1	155	5152818	5152971	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	569	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
5295323	5295323	PRJNA1078753_P_NODE_24025_length_262_cov_1.830688_g23829_i0	PRJNA1078753	24025	262	1.830688	4.79640256	Gloeothece citriformis	2546356	Bacteria	Bacteria	370	5.81e-98	NTclustered	gi\|218169741\|gb\|CP001291.1\|	65393	g23829	i0	92.075	184.469465648855	265	18	100	1	1	262	1331161	1331425	Cyanothece sp. PCC 7424, complete genome	blastn	48331	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece citriformis
7845351	7845351	PRJNA1078753_P_NODE_44407_length_226_cov_2.013072_g44211_i0	PRJNA1078753	44407	226	2.013072	4.54954272	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	418	1.7199999999999998e-112	NTclustered	gi\|745734118\|gb\|KM458372.1\|	183215	g44211	i0	100	103.353982300885	226	0	100	0	1	226	271	46	Uncultured Pleurocapsales cyanobacterium isolate OTU 00115 23S ribosomal RNA gene, partial sequence	blastn	23358	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
12946230	12946230	PRJNA1078753_P_NODE_16971_length_292_cov_1.063927_g16775_i0	PRJNA1078753	16971	292	1.063927	3.10666684	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g16775	i0	100	0.0958904109589041	28	0	10	0	136	163	3228822	3228849	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
15495165	15495165	PRJNA1078753_P_NODE_23713_length_264_cov_0.827225_g23517_i0	PRJNA1078753	23713	264	0.827225	2.183874	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	427	3.43e-115	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g23517	i0	95.833	217.893939393939	264	11	100	0	1	264	3668334	3668071	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	57524	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
16319407	16319407	PRJNA1078753_P_NODE_26433_length_253_cov_0.883333_g26237_i0	PRJNA1078753	26433	253	0.883333	2.23483249	Chroococcidiopsis	54298	Bacteria	Bacteria	457	4.16e-124	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g26237	i0	99.209	143.166007905138	253	2	100	0	1	253	679	427	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	36221	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
18044320	18044320	PRJNA1078753_P_NODE_27555_length_251_cov_0.865169_g27359_i0	PRJNA1078753	27555	251	0.865169	2.17157419	Stanieria cyanosphaera	102116	Bacteria	Bacteria	254	5.81e-63	NTclustered	gi\|428272390\|gb\|CP003656.1\|	111780	g27359	i0	90.576	0.760956175298805	191	18	76	0	61	251	29039	29229	Stanieria cyanosphaera PCC 7437 plasmid pSTA7437.03, complete sequence	blastn	191	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
19318432	19318432	PRJNA1078753_P_NODE_5296_length_458_cov_2.225974_g5100_i0	PRJNA1078753	5296	458	2.225974	10.19496092	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	726	0	NTclustered	gi\|225696247\|gb\|FJ805914.1\|	259957	g5100	i0	95.217	123.240174672489	460	20	100	2	1	458	2676	2217	Uncultured Chroococcidiopsis sp. clone AN1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	56444	726	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20143286	20143286	PRJNA1078753_P_NODE_26316_length_253_cov_1.472222_g26120_i0	PRJNA1078753	26316	253	1.472222	3.72472166	Chroococcidiopsis	54298	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g26120	i0	100	2	253	0	100	0	1	253	2604246	2603994	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	506	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis

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