metadata: contig_metadata: 21 rows where bioproject = "PRJNA851399" and tax_clade = "Cyanobacteriota/Melainabacteria group"

21 rows where bioproject = "PRJNA851399" 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
3390333	3390333	PRJNA851399_P_NODE_8523_length_284_cov_1.187234_g8070_i0	PRJNA851399	8523	284	1.187234	3.37174456	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	337	6.46e-88	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g8070	i0	88.112	165.866197183099	286	30	100	4	1	284	2874	3157	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47106	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5061973	5061973	PRJNA851399_P_NODE_23544_length_170_cov_0.925620_g23091_i0	PRJNA851399	23544	170	0.92562	1.573554	Cyanophyceae	3028117	Bacteria	Bacteria	235	1.3199999999999998e-57	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g23091	i0	91.716	293.135294117647	169	14	99	0	2	170	792834	793002	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	49833	237	0.991561181434599	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5062051	5062051	PRJNA851399_P_NODE_3744_length_557_cov_5.261811_g3313_i0	PRJNA851399	3744	557	5.261811	29.30828727	Bacteria	2	Bacteria	Bacteria	970	0	NTclustered	gi\|691483301\|gb\|KM006915.1\|	1211	g3313	i0	98.032	100.411131059246	559	9	100	2	1	557	10	568	Uncultured cyanobacterium clone 4B-30 16S ribosomal RNA gene, partial sequence	blastn	55929	979	0.990806945863126	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
7217242	7217242	PRJNA851399_P_NODE_10346_length_244_cov_1.564103_g9893_i0	PRJNA851399	10346	244	1.564103	3.81641132	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	320	5.46e-83	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g9893	i0	96.392	149.516393442623	194	7	80	0	1	194	1857875	1857682	Calothrix sp. PCC 7716 DNA, complete genome	blastn	36482	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
7217745	7217745	PRJNA851399_P_NODE_8346_length_289_cov_1.725000_g7893_i0	PRJNA851399	8346	289	1.725	4.98525	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	462	1.04e-125	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g7893	i0	95.502	165.63321799308	289	13	100	0	1	289	1951	1663	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	47868	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8492364	8492364	PRJNA851399_P_NODE_34947_length_163_cov_0.894737_g34494_i0	PRJNA851399	34947	163	0.894737	1.45842131	Halotia branconii	1620816	Bacteria	Bacteria	198	1.6499999999999999e-46	NTclustered	gi\|2500982325\|gb\|CP124543.1\|	1539056	g34494	i0	88.82	4.92638036809816	161	18	99	0	2	162	3993513	3993673	Halotia branconii CENA392 chromosome, complete genome	blastn	803	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Halotia	Halotia branconii
8492414	8492414	PRJNA851399_P_NODE_37587_length_162_cov_0.902655_g37134_i0	PRJNA851399	37587	162	0.902655	1.4623011	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	143	7.78e-30	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g37134	i0	83.23	0.993827160493827	161	21	98	6	2	159	7096800	7096957	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	161	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
9767307	9767307	PRJNA851399_P_NODE_20788_length_176_cov_1.196850_g20335_i0	PRJNA851399	20788	176	1.19685	2.106456	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g20335	i0	99.432	229.721590909091	176	1	100	0	1	176	1858894	1858719	Calothrix sp. PCC 7716 DNA, complete genome	blastn	40431	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
10162304	10162304	PRJNA851399_P_NODE_10088_length_248_cov_3.422111_g9635_i0	PRJNA851399	10088	248	3.422111	8.48683528	Bacteria	2	Bacteria	Bacteria	407	4.16e-109	NTclustered	gi\|171673241\|gb\|EU409857.1\|	1211	g9635	i0	96.356	98.3427419354839	247	9	99	0	2	248	250	4	Uncultured cyanobacterium clone 16S46 16S ribosomal RNA gene, partial sequence	blastn	24389	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11043128	11043128	PRJNA851399_P_NODE_33549_length_164_cov_0.886957_g33096_i0	PRJNA851399	33549	164	0.886957	1.45460948	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	132	1.71e-26	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g33096	i0	83.942	0.835365853658537	137	22	84	0	7	143	898325	898189	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	137	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
19965694	19965694	PRJNA851399_P_NODE_20096_length_177_cov_1.593750_g19643_i0	PRJNA851399	20096	177	1.59375	2.8209375	Geitlerinema sp. PCC 74	3100420	Bacteria	Bacteria	98.2	4.01e-22	NR	WP_041268524.1	1173025	g19643	i0	82.8	8.84745762711864	58	10	98.3	0	176	3	415	472	WP_041268524.1 Ppx/GppA phosphatase family protein [Geitlerinema sp. PCC 7407]	diamond	1566	98.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema sp. PCC 7407
21241676	21241676	PRJNA851399_P_NODE_9597_length_258_cov_1.650718_g9144_i0	PRJNA851399	9597	258	1.650718	4.25885244	Aliterella chasmolithica	2739056	Bacteria	Bacteria	350	7.44e-92	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g9144	i0	94.323	117.848837209302	229	12	89	1	4	232	2171	1944	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	30405	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
26865435	26865435	PRJNA851399_P_NODE_35501_length_163_cov_0.894737_g35048_i0	PRJNA851399	35501	163	0.894737	1.45842131	Chroococcidiopsis sp. CCALA	3088168	Bacteria	Bacteria	94.4	1.46e-22	NR	WP_106545723.1	869949	g35048	i0	89.8	0.901840490797546	49	5	90.2	0	6	152	127	175	WP_106545723.1 HdeD family acid-resistance protein [Chroococcidiopsis sp. CCALA 051]	diamond	147	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCALA 051
27212845	27212845	PRJNA851399_P_NODE_17542_length_184_cov_1.511111_g17089_i0	PRJNA851399	17542	184	1.511111	2.78044424	Microcoleus sp. PH2	44472	Bacteria	Bacteria	52	9.42e-6	NR	WP_293285320.1	2798850	g17089	i0	82.1	2.39673913043478	28	5	45.7	0	8	91	837	864	WP_293285320.1 NACHT domain-containing protein [Microcoleus sp. PH2017_40_RAT_O_B]	diamond	441	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. PH2017_40_RAT_O_B
27434441	27434441	PRJNA851399_P_NODE_20443_length_176_cov_2.409449_g19990_i0	PRJNA851399	20443	176	2.409449	4.24063024	Argonema galeatum	2942762	Bacteria	Bacteria	53.1	3.49e-7	NR	WP_249093151.1	2942762	g19990	i0	89.3	0.477272727272727	28	3	47.7	0	91	174	1	28	WP_249093151.1 DUF3007 family protein [Argonema galeatum]	diamond	84	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Argonema	Argonema galeatum
28413086	28413086	PRJNA851399_P_NODE_37366_length_162_cov_0.902655_g36913_i0	PRJNA851399	37366	162	0.902655	1.4623011	Nostoc mirabile	2907820	Bacteria	Bacteria	95.1	4.1800000000000005e-21	NR	WP_229497677.1	2907820	g36913	i0	90.4	0.962962962962963	52	5	96.3	0	157	2	213	264	WP_229497677.1 hypothetical protein [Nostoc mirabile]	diamond	156	95.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc mirabile
28886514	28886514	PRJNA851399_P_NODE_37588_length_162_cov_0.902655_g37135_i0	PRJNA851399	37588	162	0.902655	1.4623011	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	55.5	4.11e-7	NR	WP_106367551.1	2107693	g37135	i0	90	0.555555555555556	30	3	55.6	0	162	73	476	505	WP_106367551.1 mechanosensitive ion channel domain-containing protein [Chlorogloea sp. CCALA 695]	diamond	90	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
29170928	29170928	PRJNA851399_P_NODE_36109_length_163_cov_0.894737_g35656_i0	PRJNA851399	36109	163	0.894737	1.45842131	Chroococcidiopsis sp. CCALA	3088168	Bacteria	Bacteria	89.4	3.59e-19	NR	WP_199197606.1	869949	g35656	i0	75.9	1.98773006134969	54	13	99.4	0	1	162	80	133	WP_199197606.1 relaxase/mobilization nuclease domain-containing protein [Chroococcidiopsis sp. CCALA 051]	diamond	324	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCALA 051
29431386	29431386	PRJNA851399_P_NODE_38689_length_162_cov_0.902655_g38236_i0	PRJNA851399	38689	162	0.902655	1.4623011	Tolypothrichaceae	119859	Bacteria	Bacteria	95.1	3.42e-21	NR	WP_039738543.1	482630	g38236	i0	83	1.96296296296296	53	9	98.1	0	2	160	202	254	WP_039738543.1 serine/threonine-protein kinase [Hassallia byssoidea]	diamond	318	95.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
32141454	32141454	PRJNA851399_P_NODE_17838_length_183_cov_1.522388_g17385_i0	PRJNA851399	17838	183	1.522388	2.78597004	Microcoleus sp. herbarium8	3055436	Bacteria	Bacteria	72.4	1.5700000000000001e-13	NR	WP_369293223.1	3055436	g17385	i0	64.4	0.967213114754098	59	21	96.7	0	179	3	14	72	WP_369293223.1 TolB family protein, partial [Microcoleus sp. herbarium8]	diamond	177	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium8
32204738	32204738	PRJNA851399_P_NODE_27938_length_166_cov_0.871795_g27485_i0	PRJNA851399	27938	166	0.871795	1.4471797	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	113	2.0900000000000003e-27	NR	WP_106369885.1	2107693	g27485	i0	94.5	0.993975903614458	55	3	99.4	0	2	166	92	146	WP_106369885.1 hypothetical protein [Chlorogloea sp. CCALA 695]	diamond	165	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695

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