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

18 rows where analysis = "blastn", bioproject = "PRJNA1061474" 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
178750	178750	PRJNA1061474_P_NODE_41901_length_269_cov_1.301020_g41655_i0	PRJNA1061474	41901	269	1.30102	3.4997438	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	4.53e-114	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g41655	i0	97.951	130.118959107807	244	5	91	0	1	244	2848	3091	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35002	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6557119	6557119	PRJNA1061474_P_NODE_7486_length_799_cov_17.705234_g7277_i0	PRJNA1061474	7486	799	17.705234	141.46481966	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1086	0	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g7277	i0	93.227	104.504380475594	753	28	93	17	1	742	2348	1608	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	83499	1086	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7830537	7830537	PRJNA1061474_P_NODE_19307_length_448_cov_1.544000_g19061_i0	PRJNA1061474	19307	448	1.544	6.91712	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	717	0	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g19061	i0	95.546	112.279017857143	449	18	100	2	1	448	2746	2299	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	50301	717	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7831174	7831174	PRJNA1061474_P_NODE_38807_length_286_cov_1.446009_g38561_i0	PRJNA1061474	38807	286	1.446009	4.13558574	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	472	1.71e-128	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g38561	i0	98.148	197.776223776224	270	5	94	0	17	286	1858904	1858635	Calothrix sp. PCC 7716 DNA, complete genome	blastn	56564	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
9106533	9106533	PRJNA1061474_P_NODE_52648_length_245_cov_0.895349_g52402_i0	PRJNA1061474	52648	245	0.895349	2.19360505	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	337	5.45e-88	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g52402	i0	93.392	141.526530612245	227	15	93	0	19	245	261	35	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	34674	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
9939835	9939835	PRJNA1061474_P_NODE_44908_length_253_cov_1.144444_g44662_i0	PRJNA1061474	44908	253	1.144444	2.89544332	Cyanophyceae	3028117	Bacteria	Bacteria	291	4.4699999999999996e-74	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g44662	i0	97.093	113.707509881423	172	5	68	0	67	238	2209	2038	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	28768	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9939861	9939861	PRJNA1061474_P_NODE_52048_length_246_cov_0.890173_g51802_i0	PRJNA1061474	52048	246	0.890173	2.18982558	Nostoc	1177	Bacteria	Bacteria	65.8	2.85e-6	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g51802	i0	95.238	32.8089430894309	42	1	17	1	70	111	5336605	5336565	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	8071	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
9939874	9939874	PRJNA1061474_P_NODE_7528_length_797_cov_7.599448_g7318_i0	PRJNA1061474	7528	797	7.599448	60.56760056	Chroococcidiopsis	54298	Bacteria	Bacteria	907	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g7318	i0	87.814	112.820577164366	796	70	98	11	1	779	794858	795643	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	89918	907	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
10381392	10381392	PRJNA1061474_P_NODE_24409_length_387_cov_2.292994_g24163_i0	PRJNA1061474	24409	387	2.292994	8.87388678	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	544	4.999999999999999e-150	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g24163	i0	92.072	201.855297157623	391	24	100	7	1	387	387	774	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	78118	544	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
11656548	11656548	PRJNA1061474_P_NODE_21410_length_420_cov_1.965418_g21164_i0	PRJNA1061474	21410	420	1.965418	8.2547556	Pseudanabaena mucicola	71190	Bacteria	Bacteria	244	6.22e-60	NTclustered	gi\|2522923893\|gb\|CP097329.1\|	2942274	g21164	i0	79.765	95.4309523809524	341	65	81	4	69	407	2376552	2376890	Pseudanabaena mucicola str. Chao 1806 chromosome, complete genome	blastn	40081	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena mucicola
12490551	12490551	PRJNA1061474_P_NODE_2410_length_1370_cov_16.488049_g2302_i0	PRJNA1061474	2410	1370	16.488049	225.8862713	Oscillatoriales	1150	Bacteria	Bacteria	2409	0	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g2302	i0	98.395	176.728467153285	1371	21	100	1	1	1370	2143	3513	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	242118	2409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14207695	14207695	PRJNA1061474_P_NODE_54112_length_244_cov_0.900585_g53866_i0	PRJNA1061474	54112	244	0.900585	2.1974274	Microcoleus vaginatus	119532	Bacteria	Bacteria	368	1.92e-97	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g53866	i0	93.852	98.8155737704918	244	15	100	0	1	244	2208233	2208476	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	24111	368	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
19303939	19303939	PRJNA1061474_P_NODE_2716_length_1300_cov_10.469438_g2604_i0	PRJNA1061474	2716	1300	10.469438	136.102694	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2163	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g2604	i0	96.846	101.507692307692	1300	29	100	7	1	1300	1988	3275	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	131960	2163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19304079	19304079	PRJNA1061474_P_NODE_31676_length_328_cov_1.301961_g31430_i0	PRJNA1061474	31676	328	1.301961	4.27043208	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	460	4.329999999999999e-125	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g31430	i0	93.548	148.628048780488	310	19	95	1	19	328	1670	1978	Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48750	460	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20138069	20138069	PRJNA1061474_P_NODE_20896_length_426_cov_2.164306_g20650_i0	PRJNA1061474	20896	426	2.164306	9.21994356	Chroococcidiopsis	54298	Bacteria	Bacteria	580	4.239999999999999e-161	NTclustered	gi\|389547671\|gb\|JQ402599.1\|	1211	g20650	i0	99.375	97.0774647887324	320	2	75	0	1	320	320	1	Uncultured cyanobacterium clone CNY_03000 16S ribosomal RNA gene, partial sequence	blastn	41355	580	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21855490	21855490	PRJNA1061474_P_NODE_40658_length_276_cov_1.137931_g40412_i0	PRJNA1061474	40658	276	1.137931	3.14068956	Nodosilinea bijugata	264745	Bacteria	Bacteria	134	8.810000000000001e-27	NTclustered	gi\|1897879576\|gb\|MT946553.1\|	2768011	g40412	i0	86.29	60.5326086956522	124	15	45	2	66	188	2106	2228	Nodosilinea bijugata SY-4-1-H 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	16707	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea bijugata
22688498	22688498	PRJNA1061474_P_NODE_36518_length_299_cov_1.013274_g36272_i0	PRJNA1061474	36518	299	1.013274	3.02968926	Calothrix	1186	Bacteria	Bacteria	531	2.9299999999999992e-146	NTclustered	gi\|745734158\|gb\|KM458324.1\|	332972	g36272	i0	98.667	181.682274247492	300	3	100	1	1	299	358	59	Uncultured Calothrix sp. isolate OTU 00041 23S ribosomal RNA gene, partial sequence	blastn	54323	536	0.990671641791045	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	uncultured Calothrix sp.
23964153	23964153	PRJNA1061474_P_NODE_8659_length_733_cov_19.616667_g8438_i0	PRJNA1061474	8659	733	19.616667	143.79016911	Microcoleus	44471	Bacteria	Bacteria	1223	0	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g8438	i0	97.878	133.507503410641	707	15	96	0	1	707	132694	133400	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	97861	1223	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus

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