metadata: contig_metadata: 18 rows where bioproject = "PRJNA939370" and tax_clade = "Cyanobacteriota/Melainabacteria group"

18 rows where bioproject = "PRJNA939370" 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
914640	914640	PRJNA939370_S_NODE_81_length_823_cov_6.828165_g54_i0	PRJNA939370	81	823	6.828165	56.19579795	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1269	0	NTclustered	gi\|225696278\|gb\|FJ805945.1\|	259957	g54	i0	94.532	142.893074119077	823	43	99	2	2	823	2897	2076	Uncultured Chroococcidiopsis sp. clone AS5_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	117601	1269	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1256172	1256172	PRJNA939370_S_NODE_481_length_417_cov_1.163043_g429_i0	PRJNA939370	481	417	1.163043	4.84988931	Synechococcus	1129	Bacteria	Bacteria	398	4.469999999999998e-106	NTclustered	gi\|2672429148\|gb\|CP030139.2\|	2219813	g429	i0	84.3	659.570743405276	414	57	99	8	7	417	1777781	1777373	Synechococcus elongatus PCC 11801 chromosome, complete genome	blastn	275041	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus elongatus
3465480	3465480	PRJNA939370_S_NODE_263_length_527_cov_4.638075_g215_i0	PRJNA939370	263	527	4.638075	24.44265525	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	704	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g215	i0	92.2	133.981024667932	500	36	94	3	29	526	1604	2102	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	70608	704	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3465494	3465494	PRJNA939370_S_NODE_383_length_470_cov_7.325416_g331_i0	PRJNA939370	383	470	7.325416	34.4294552	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	730	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g331	i0	94.681	106.174468085106	470	25	100	0	1	470	2422	2891	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	49902	730	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4743018	4743018	PRJNA939370_S_NODE_2284_length_182_cov_0.721805_g2232_i0	PRJNA939370	2284	182	0.721805	1.3136851	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	261	2.36e-65	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g2232	i0	92.778	213.983516483516	180	13	99	0	3	182	1859120	1859299	Calothrix sp. PCC 7716 DNA, complete genome	blastn	38945	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
5084474	5084474	PRJNA939370_S_NODE_384_length_470_cov_7.275534_g332_i0	PRJNA939370	384	470	7.275534	34.1950098	Cyanophyceae	3028117	Bacteria	Bacteria	730	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g332	i0	94.703	111.53829787234	472	21	100	3	1	470	2422	2891	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	52423	730	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6360209	6360209	PRJNA939370_S_NODE_3225_length_161_cov_2.794643_g3173_i0	PRJNA939370	3225	161	2.794643	4.49937523	Cyanophyceae	3028117	Bacteria	Bacteria	292	7.24e-75	NTclustered	gi\|46409889\|gb\|AY584514.1\|	272127	g3173	i0	99.379	192.428571428571	161	1	100	0	1	161	471	311	Oscillatoria sp. CCAP 1459/26 23S ribosomal RNA gene, partial sequence	blastn	30981	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. CCAP 1459/26
12393823	12393823	PRJNA939370_S_NODE_1630_length_215_cov_1.144578_g1578_i0	PRJNA939370	1630	215	1.144578	2.4608427	Wilmottia koreana	2759957	Bacteria	Bacteria	339	1.2999999999999998e-88	NTclustered	gi\|1743541374\|gb\|MN473879.1\|	2613809	g1578	i0	95.327	184.348837209302	214	9	99	1	1	214	2371	2159	Wilmottia koreana FBCC-A812 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39635	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Wilmottia	Wilmottia koreana
14942586	14942586	PRJNA939370_S_NODE_2872_length_166_cov_0.871795_g2820_i0	PRJNA939370	2872	166	0.871795	1.4471797	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	195	2.18e-45	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g2820	i0	87.952	157.102409638554	166	19	100	1	1	166	3262	3098	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26079	195	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14942598	14942598	PRJNA939370_S_NODE_732_length_343_cov_2.959184_g680_i0	PRJNA939370	732	343	2.959184	10.15000112	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	527	4.4199999999999986e-145	NTclustered	gi\|225696177\|gb\|FJ805844.1\|	259957	g680	i0	95.224	133.790087463557	335	13	97	3	1	334	3477	3145	Uncultured Chroococcidiopsis sp. clone AU1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	45890	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16217634	16217634	PRJNA939370_S_NODE_2313_length_180_cov_1.366412_g2261_i0	PRJNA939370	2313	180	1.366412	2.4595416	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	292	8.26e-75	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g2261	i0	96.61	145.183333333333	177	4	98	2	1	176	7	182	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26133	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20041283	20041283	PRJNA939370_S_NODE_1436_length_230_cov_0.911602_g1384_i0	PRJNA939370	1436	230	0.911602	2.0966846	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	348	2.34e-91	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g1384	i0	93.913	153.3	230	14	100	0	1	230	1524	1753	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	35259	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20041294	20041294	PRJNA939370_S_NODE_216_length_577_cov_3.543561_g168_i0	PRJNA939370	216	577	3.543561	20.44634697	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	723	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g168	i0	89.483	120.641247833622	580	50	99	7	1	575	2718	3291	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	69610	723	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20382447	20382447	PRJNA939370_S_NODE_1116_length_264_cov_1.046512_g1064_i0	PRJNA939370	1116	264	1.046512	2.76279168	Chroococcidiopsis	54298	Bacteria	Bacteria	385	2.09e-102	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g1064	i0	93.156	169.087121212121	263	17	99	1	3	264	795164	795426	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	44639	385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
21316733	21316733	PRJNA939370_S_NODE_1537_length_221_cov_1.267442_g1485_i0	PRJNA939370	1537	221	1.267442	2.80104682	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	337	4.83e-88	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g1485	i0	94.118	137.180995475113	221	13	100	0	1	221	2844	2624	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	30317	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21316742	21316742	PRJNA939370_S_NODE_2077_length_190_cov_0.929078_g2025_i0	PRJNA939370	2077	190	0.929078	1.7652482	Microcoleus sp. PCC 8701	272133	Bacteria	Bacteria	270	4.14e-68	NTclustered	gi\|46409899\|gb\|AY584524.1\|	272133	g2025	i0	92.188	161.626315789474	192	13	100	1	1	190	1005	814	Microcoleus sp. PCC 8701 23S ribosomal RNA gene, partial sequence	blastn	30709	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. PCC 8701
21316744	21316744	PRJNA939370_S_NODE_2337_length_179_cov_1.600000_g2285_i0	PRJNA939370	2337	179	1.6	2.864	Calothrix sp. UAM 373	995104	Bacteria	Bacteria	315	1.75e-81	NTclustered	gi\|325960266\|gb\|HM751855.1\|	995104	g2285	i0	98.324	103.117318435754	179	3	100	0	1	179	19	197	Calothrix sp. UAM 373 16S ribosomal RNA gene, partial sequence	blastn	18458	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. UAM 373
23867068	23867068	PRJNA939370_S_NODE_2359_length_178_cov_2.589147_g2307_i0	PRJNA939370	2359	178	2.589147	4.60868166	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	300	4.87e-77	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g2307	i0	97.191	219.561797752809	178	4	100	1	1	178	1858810	1858986	Calothrix sp. PCC 7716 DNA, complete genome	blastn	39082	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716

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