metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJEB7799" and tax

22 rows where analysis = "blastn", bioproject = "PRJEB7799" 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
12892395	12892395	PRJEB7799_P_NODE_1491_length_226_cov_6.446701_g1484_i0	PRJEB7799	1491	226	6.446701	14.56954426	Aliterella chasmolithica	2739056	Bacteria	Bacteria	315	2.32e-81	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g1484	i0	94.581	122.119469026549	203	11	90	0	3	205	2169	1967	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	27599	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
25526203	25526203	PRJEB7799a_S_NODE_377_length_507_cov_12.230932_g345_i0	PRJEB7799	377	507	12.230932	62.01082524	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	617	3.8999999999999986e-172	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g345	i0	90.275	128.905325443787	473	44	93	2	20	491	2438	1967	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	65355	617	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
25527320	25527320	PRJEB7799i_S_NODE_2921_length_265_cov_30.108696_g2891_i0	PRJEB7799	2921	265	30.108696	79.7880444	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	366	7.62e-97	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g2891	i0	97.222	127.845283018868	216	6	82	0	17	232	1678	1463	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33879	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25616460	25616460	PRJEB7799a_S_NODE_18465_length_153_cov_19.779661_g18430_i0	PRJEB7799	18465	153	19.779661	30.26288133	Synechococcus	1129	Bacteria	Bacteria	73.1	9.62e-9	NTclustered	gi\|1104554094\|gb\|CP018091.1\|	1916956	g18430	i0	92.308	32.3790849673203	52	3	33	1	35	85	1551754	1551805	Synechococcus sp. SynAce01 chromosome, complete genome	blastn	4954	73.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. SynAce01
25617516	25617516	PRJEB7799q_S_NODE_217_length_374_cov_4.454277_g207_i0	PRJEB7799	217	374	4.454277	16.65899598	Chroococcidiopsidales	1890505	Bacteria	Bacteria	442	1.8099999999999994e-119	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g207	i0	91.615	119.109625668449	322	24	86	3	27	346	1785	1465	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44547	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25663632	25663632	PRJEB7799l_S_NODE_10938_length_165_cov_22.430769_g10909_i0	PRJEB7799	10938	165	22.430769	37.01076885	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	268	1.26e-67	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g10909	i0	96.319	125.551515151515	163	6	99	0	3	165	1967	2129	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	20716	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
25664409	25664409	PRJEB7799n_S_NODE_3818_length_232_cov_10.182741_g3781_i0	PRJEB7799	3818	232	10.182741	23.62395912	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	331	2.38e-86	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g3781	i0	94.811	129.875	212	11	91	0	16	227	2178	1967	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	30131	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
25752688	25752688	PRJEB7799a_S_NODE_10610_length_181_cov_2.000000_g10575_i0	PRJEB7799	10610	181	2	3.62	Aliterella	1827277	Bacteria	Bacteria	281	1.8e-71	NTclustered	gi\|285308333\|emb\|AM940922.1\|	1211	g10575	i0	100	83.9558011049724	152	0	84	0	1	152	686	535	Uncultured cyanobacterium partial 16S rRNA gene, clone B9_97	blastn	15196	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
25753787	25753787	PRJEB7799q_S_NODE_354_length_323_cov_5.131944_g344_i0	PRJEB7799	354	323	5.131944	16.57617912	Gloeocapsopsis	693222	Bacteria	Bacteria	492	1.5099999999999996e-134	NTclustered	gi\|1142095202\|gb\|KU847399.1\|	1433147	g344	i0	96.358	100.28173374613	302	5	93	5	15	313	3490	3192	Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	32391	492	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
25798780	25798780	PRJEB7799c_S_NODE_4907_length_199_cov_2.365854_g4884_i0	PRJEB7799	4907	199	2.365854	4.70804946	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	165	2.13e-36	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g4884	i0	89.474	179.256281407035	133	10	66	3	68	198	2150586	2150716	Leptolyngbya sp. 7M chromosome	blastn	35672	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
25800403	25800403	PRJEB7799n_S_NODE_10515_length_160_cov_4.008000_g10478_i0	PRJEB7799	10515	160	4.008	6.4128	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	246	5.67e-61	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g10478	i0	96.026	138.7875	151	6	94	0	10	160	1678	1528	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22206	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25888788	25888788	PRJEB7799g_S_NODE_1571_length_222_cov_2.684492_g1355_i0	PRJEB7799	1571	222	2.684492	5.95957224	root	1	Root_unresolved	Root_unresolved	381	2.2099999999999994e-101	NTclustered	gi\|63022551\|gb\|DQ004310.1\|	1211	g1355	i0	100	169.837837837838	206	0	93	0	17	222	223	18	Uncultured cyanobacterium clone PEN12 16S ribosomal RNA gene, partial sequence	blastn	37704	383	0.994778067885117	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
25935457	25935457	PRJEB7799g_S_NODE_1212_length_241_cov_13.281553_g996_i0	PRJEB7799	1212	241	13.281553	32.00854273	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	337	5.35e-88	NTclustered	gi\|225696259\|gb\|FJ805926.1\|	259957	g996	i0	92.735	122.315352697095	234	16	97	1	1	233	1702	1935	Uncultured Chroococcidiopsis sp. clone AS3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29478	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25936603	25936603	PRJEB7799n_S_NODE_11364_length_156_cov_1.396694_g11327_i0	PRJEB7799	11364	156	1.396694	2.17884264	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	161	2.05e-35	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g11327	i0	87.324	354.769230769231	142	16	90	2	17	156	1906	1765	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	55344	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25936795	25936795	PRJEB7799n_S_NODE_5868_length_196_cov_4.807453_g5831_i0	PRJEB7799	5868	196	4.807453	9.42260788	Chroococcidiopsis sp. CCMEE	3088168	Bacteria	Bacteria	257	3.3500000000000004e-64	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g5831	i0	91.099	164.045918367347	191	16	97	1	1	190	2350	2540	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32153	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
26024833	26024833	PRJEB7799a_S_NODE_4236_length_236_cov_5.656716_g4201_i0	PRJEB7799	4236	236	5.656716	13.34984976	Bacteria	2	Bacteria	Bacteria	366	6.66e-97	NTclustered	gi\|389547670\|gb\|JQ402598.1\|	1211	g4201	i0	99.02	83.1525423728814	204	2	86	0	33	236	1	204	Uncultured cyanobacterium clone CNY_02999 16S ribosomal RNA gene, partial sequence	blastn	19624	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26073571	26073571	PRJEB7799p_S_NODE_5941_length_221_cov_4.897849_g5918_i0	PRJEB7799	5941	221	4.897849	10.82424629	Chroococcidiopsis sp. CCMEE	3088168	Bacteria	Bacteria	243	1.08e-59	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g5918	i0	91.525	150.217194570136	177	14	80	1	13	188	2518	2342	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33198	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
26161175	26161175	PRJEB7799d_S_NODE_4077_length_179_cov_2.534722_g4067_i0	PRJEB7799	4077	179	2.534722	4.53715238	Bacteria	2	Bacteria	Bacteria	303	3.79e-78	NTclustered	gi\|148615249\|gb\|EF188559.1\|	1211	g4067	i0	97.207	99.8715083798883	179	5	100	0	1	179	246	68	Uncultured cyanobacterium clone 295 16S ribosomal RNA gene, partial sequence	blastn	17877	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26207297	26207297	PRJEB7799c_S_NODE_7686_length_182_cov_1.578231_g7663_i0	PRJEB7799	7686	182	1.578231	2.87238042	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	185	1.46e-42	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g7663	i0	88.961	115.274725274725	154	11	83	6	1	151	4828895	4829045	Leptolyngbya sp. 7M chromosome	blastn	20980	185	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
26342923	26342923	PRJEB7799c_S_NODE_2151_length_252_cov_7.460829_g2128_i0	PRJEB7799	2151	252	7.460829	18.80128908	Leptolyngbya sp. BL	47254	Bacteria	Bacteria	261	3.49e-65	NTclustered	gi\|1949996095\|gb\|CP046155.1\|	1115757	g2128	i0	88.732	105.154761904762	213	24	85	0	17	229	785238	785026	Leptolyngbya sp. BL0902 chromosome, complete genome	blastn	26499	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL0902
26344984	26344984	PRJEB7799o_S_NODE_2175_length_185_cov_15.693333_g2167_i0	PRJEB7799	2175	185	15.693333	29.03266605	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	270	4.01e-68	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g2167	i0	94.798	128.4	173	9	94	0	1	173	2139	1967	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	23754	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
26481785	26481785	PRJEB7799p_S_NODE_3264_length_271_cov_38.220339_g3241_i0	PRJEB7799	3264	271	38.220339	103.57711869	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	396	9.969999999999997e-106	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g3241	i0	94.862	114.974169741697	253	13	93	0	19	271	1967	2219	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	31158	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica

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