metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA980839" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA980839" 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
959242	959242	PRJNA980839_P_NODE_241821_length_236_cov_2.601227_g238037_i0	PRJNA980839	241821	236	2.601227	6.13889572	cyanobacterium NIES-2125	2510788	Bacteria	Bacteria	370	5.14e-98	NTclustered	gi\|1566846232\|dbj\|LC455610.1\|	2510788	g238037	i0	94.915	213.423728813559	236	12	100	0	1	236	758	523	Cyanobacterium NIES-2125 gene for 23S ribosomal RNA, partial sequence	blastn	50368	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-2125
2234863	2234863	PRJNA980839_P_NODE_35742_length_809_cov_2.524457_g32262_i0	PRJNA980839	35742	809	2.524457	20.42285713	uncultured Cyanothece sp.	259951	Bacteria	Bacteria	741	0	NTclustered	gi\|643030817\|gb\|KF124702.1\|	259951	g32262	i0	99.272	23.2088998763906	412	0	51	3	229	639	410	1	Uncultured Cyanothece sp. clone GTFKKJB01DOFK1 genomic sequence	blastn	18776	741	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	uncultured Cyanothece sp.
2545480	2545480	PRJNA980839_P_NODE_131082_length_308_cov_3.387234_g127298_i0	PRJNA980839	131082	308	3.387234	10.43268072	Microcoleus	44471	Bacteria	Bacteria	505	1.8399999999999998e-138	NTclustered	gi\|1532298831\|gb\|MK275410.1\|	1211	g127298	i0	96.417	99.3409090909091	307	10	99	1	2	308	346	651	Uncultured cyanobacterium clone K6_120 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	30597	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
3508284	3508284	PRJNA980839_P_NODE_165483_length_274_cov_1.378109_g161699_i0	PRJNA980839	165483	274	1.378109	3.77601866	Spirirestis rafaelensis	293980	Bacteria	Bacteria	292	1.3599999999999999e-74	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g161699	i0	97.647	180.57299270073	170	4	96	0	1	170	456	287	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	49477	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
3509011	3509011	PRJNA980839_P_NODE_202423_length_250_cov_0.870056_g198639_i0	PRJNA980839	202423	250	0.870056	2.17514	Cylindrospermum sp. NIES-4074	2005457	Bacteria	Bacteria	226	1.26e-54	NTclustered	gi\|1210208533\|dbj\|AP018269.1\|	2005457	g198639	i0	83.682	7.076	239	39	96	0	1	239	4907288	4907526	Cylindrospermum sp. NIES-4074 DNA, nearly complete genome	blastn	1769	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum sp. NIES-4074
4785013	4785013	PRJNA980839_P_NODE_119344_length_325_cov_7.408730_g115560_i0	PRJNA980839	119344	325	7.40873	24.0783725	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	545	1.15e-150	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g115560	i0	96.923	168.990769230769	325	10	100	0	1	325	1799	1475	Uncultured Chroococcidiopsis sp. clone AR2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	54922	545	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4786655	4786655	PRJNA980839_P_NODE_201524_length_250_cov_0.870056_g197740_i0	PRJNA980839	201524	250	0.870056	2.17514	Pseudanabaena mucicola	71190	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2522923893\|gb\|CP097329.1\|	2942274	g197740	i0	100	0.112	28	0	11	0	126	153	658986	659013	Pseudanabaena mucicola str. Chao 1806 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena mucicola
5098365	5098365	PRJNA980839_P_NODE_177984_length_264_cov_1.612565_g174200_i0	PRJNA980839	177984	264	1.612565	4.2571716	Drouetiella	2303513	Bacteria	Bacteria	483	7.219999999999998e-132	NTclustered	gi\|2312649309\|gb\|OP577849.1\|	2983376	g174200	i0	99.621	159.333333333333	264	1	100	0	1	264	1931	2194	Drouetiella lurida ACKU668 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	42064	483	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella lurida
5098905	5098905	PRJNA980839_P_NODE_74484_length_444_cov_2.420485_g70700_i0	PRJNA980839	74484	444	2.420485	10.7469534	root	1	Root_unresolved	Root_unresolved	800	0	NTclustered	gi\|53773079\|gb\|AY711604.1\|	1211	g70700	i0	99.321	115.531531531532	442	3	99	0	2	443	705	264	Uncultured cyanobacterium clone SIMO-2238 16S ribosomal RNA gene, partial sequence	blastn	51296	800	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9887451	9887451	PRJNA980839_P_NODE_247468_length_208_cov_5.481481_g243684_i0	PRJNA980839	247468	208	5.481481	11.40148048	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	159	1.04e-34	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g243684	i0	80.676	0.995192307692308	207	38	99	2	1	206	1165757	1165552	Gloeocapsa sp. PCC 7428, complete genome	blastn	207	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
20084707	20084707	PRJNA980839_P_NODE_189276_length_256_cov_1.683060_g185492_i0	PRJNA980839	189276	256	1.68306	4.3086336	Nostoc flagelliforme	1306274	Bacteria	Bacteria	324	4.47e-84	NTclustered	gi\|308205634\|gb\|HQ291116.1\|	676037	g185492	i0	90.909	90.8515625	242	20	94	2	1	240	1667	1426	Nostoc flagelliforme str. Sunitezuoqi clone 44 hypothetical protein (Nfla_4401), hypothetical protein (Nfla_4402), amidohydrolase (Nfla_4403), brefeldin A esterase (Nfla_4404), and 6-phosphogluconate dehydrogenase (Nfla_4405) genes, complete cds	blastn	23258	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
20085239	20085239	PRJNA980839_P_NODE_216276_length_246_cov_1.578035_g212492_i0	PRJNA980839	216276	246	1.578035	3.8819661	Nostoc sp. UHCC 0870	2914041	Bacteria	Bacteria	383	6.94e-102	NTclustered	gi\|2190707562\|gb\|CP091913.1\|	2914041	g212492	i0	94.715	190.345528455285	246	13	100	0	1	246	200264	200019	Nostoc sp. UHCC 0870 chromosome, complete genome	blastn	46825	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0870
23909412	23909412	PRJNA980839_P_NODE_12399_length_1808_cov_21.127378_g4140_i2	PRJNA980839	12399	1808	21.127378	381.98299424	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	2682	0	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g4140	i2	93.488	107.696349557522	1812	106	100	11	1	1808	21	1824	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	194715	2682	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
25184196	25184196	PRJNA980839_P_NODE_179580_length_263_cov_1.405263_g175796_i0	PRJNA980839	179580	263	1.405263	3.69584169	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	200	8.099999999999998e-47	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g175796	i0	80.916	3.26996197718631	262	42	98	7	6	263	4342848	4342591	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	860	200	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29

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