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

16 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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
2305850	2305850	PRJNA1126198_P_NODE_48342_length_401_cov_1.353659_g47625_i0	PRJNA1126198	48342	401	1.353659	5.42817259	Oscillatoriales	1150	Bacteria	Bacteria	730	0	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g47625	i0	99.501	139.985037406484	401	2	100	0	1	401	1584	1184	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	56134	730	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
3581058	3581058	PRJNA1126198_P_NODE_443043_length_244_cov_1.789474_g442322_i0	PRJNA1126198	443043	244	1.789474	4.36631656	root	1	Root_unresolved	Root_unresolved	363	8.949999999999999e-96	NTclustered	gi\|389547084\|gb\|JQ402012.1\|	1211	g442322	i0	100	101.639344262295	196	0	99	0	1	196	295	490	Uncultured cyanobacterium clone CNY_02268 16S ribosomal RNA gene, partial sequence	blastn	24800	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
7934646	7934646	PRJNA1126198_P_NODE_419767_length_247_cov_0.879310_g419046_i0	PRJNA1126198	419767	247	0.87931	2.1718957	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	390	4.1699999999999997e-104	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g419046	i0	97.788	1.29554655870445	226	5	91	0	22	247	5573667	5573892	Anabaena sp. YBS01 chromosome, complete genome	blastn	320	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
8683399	8683399	PRJNA1126198_P_NODE_202867_length_291_cov_5.756881_g202147_i0	PRJNA1126198	202867	291	5.756881	16.75252371	Oscillatoriales	1150	Bacteria	Bacteria	532	7.9e-147	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g202147	i0	99.656	144.676975945017	291	1	100	0	1	291	1237	947	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	42101	532	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
10485070	10485070	PRJNA1126198_P_NODE_381689_length_250_cov_1.847458_g380968_i0	PRJNA1126198	381689	250	1.847458	4.618645	Aliterella chasmolithica	2739056	Bacteria	Bacteria	411	3.239999999999999e-110	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g380968	i0	99.123	157.956	228	2	91	0	1	228	2273	2500	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	39489	411	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
11233674	11233674	PRJNA1126198_P_NODE_259349_length_275_cov_3.153465_g258628_i0	PRJNA1126198	259349	275	3.153465	8.67202875	Oscillatoria	1158	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|389547084\|gb\|JQ402012.1\|	1211	g258628	i0	100	100.003636363636	275	0	100	0	1	275	4	278	Uncultured cyanobacterium clone CNY_02268 16S ribosomal RNA gene, partial sequence	blastn	27501	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11233917	11233917	PRJNA1126198_P_NODE_5229_length_773_cov_3.360000_g4632_i0	PRJNA1126198	5229	773	3.36	25.9728	Chroococcidiopsis	54298	Bacteria	Bacteria	1190	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g4632	i0	94.459	104.941785252264	776	38	99	5	2	773	794243	795017	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	81120	1199	0.992493744787323	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
11759723	11759723	PRJNA1126198_P_NODE_173070_length_303_cov_1.265217_g172350_i0	PRJNA1126198	173070	303	1.265217	3.83360751	uncultured cyanobacterium	1211	Bacteria	Bacteria	484	2.3499999999999998e-132	NTclustered	gi\|389547676\|gb\|JQ402604.1\|	1211	g172350	i0	98.893	103.732673267327	271	3	89	0	33	303	1	271	Uncultured cyanobacterium clone CNY_03005 16S ribosomal RNA gene, partial sequence	blastn	31431	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11759762	11759762	PRJNA1126198_P_NODE_190770_length_296_cov_1.260090_g190050_i0	PRJNA1126198	190770	296	1.26009	3.7298664	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	5.0599999999999996e-114	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g190050	i0	93.08	114.547297297297	289	20	98	0	8	296	1921	1633	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33906	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13783530	13783530	PRJNA1126198_P_NODE_185331_length_298_cov_1.368889_g184611_i0	PRJNA1126198	185331	298	1.368889	4.07928922	root	1	Root_unresolved	Root_unresolved	551	2.239999999999999e-152	NTclustered	gi\|151349732\|gb\|EF662441.1\|	1211	g184611	i0	100	109.986577181208	298	0	100	0	1	298	810	513	Uncultured cyanobacterium clone GASP-MA1S2_D03 16S ribosomal RNA gene, partial sequence	blastn	32776	551	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14310204	14310204	PRJNA1126198_P_NODE_268332_length_273_cov_1.740000_g267611_i0	PRJNA1126198	268332	273	1.74	4.7502	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	333	7.989999999999999e-87	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g267611	i0	89.259	135.322344322344	270	24	98	3	6	272	2200	2467	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	36943	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
17608174	17608174	PRJNA1126198_P_NODE_464114_length_242_cov_1.822485_g463393_i0	PRJNA1126198	464114	242	1.822485	4.4104137	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	60.2	1.3e-4	NTclustered	gi\|428256439\|gb\|CP003642.1\|	56107	g463393	i0	100	7.72727272727273	32	0	13	0	132	163	2768753	2768722	Cylindrospermum stagnale PCC 7417, complete genome	blastn	1870	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
20682704	20682704	PRJNA1126198_P_NODE_232417_length_283_cov_1.176190_g231696_i0	PRJNA1126198	232417	283	1.17619	3.3286177	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	366	8.21e-97	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g231696	i0	90.175	108.088339222615	285	23	99	5	2	283	3200	2918	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30589	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20682800	20682800	PRJNA1126198_P_NODE_281397_length_270_cov_1.563452_g280676_i0	PRJNA1126198	281397	270	1.563452	4.2213204	Cyanobium gracile	59930	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|427344508\|gb\|CP003495.1\|	292564	g280676	i0	100	0.103703703703704	28	0	10	0	232	259	3220364	3220391	Cyanobium gracile PCC 6307, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
21432188	21432188	PRJNA1126198_P_NODE_224997_length_285_cov_1.325472_g224276_i0	PRJNA1126198	224997	285	1.325472	3.7775952	Nostocaceae	1162	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g224276	i0	100	165.677192982456	285	0	100	0	1	285	3059667	3059951	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	47218	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
23233449	23233449	PRJNA1126198_P_NODE_162179_length_307_cov_2.260684_g161460_i0	PRJNA1126198	162179	307	2.260684	6.94029988	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	484	2.3799999999999994e-132	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g161460	i0	95.13	105.055374592834	308	14	100	1	1	307	2118	2425	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	32252	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana

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