metadata: contig_metadata: 30 rows where bioproject = "PRJNA888821" and tax

30 rows where bioproject = "PRJNA888821" 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
1241897	1241897	PRJNA888821_P_NODE_38501_length_243_cov_0.905882_g38418_i0	PRJNA888821	38501	243	0.905882	2.20129326	Nostocaceae	1162	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|46409894\|gb\|AY584519.1\|	63737	g38418	i0	100	293.452674897119	243	0	100	0	1	243	402	644	Nostoc punctiforme PCC 73102 23S ribosomal RNA gene, partial sequence	blastn	71309	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
3413722	3413722	PRJNA888821_P_NODE_3803_length_363_cov_11.082759_g3722_i0	PRJNA888821	3803	363	11.082759	40.23041517	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	448	3.759999999999999e-121	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g3722	i0	89.041	105.407713498623	365	35	100	3	1	363	2151596	2151957	Leptolyngbya sp. 7M chromosome	blastn	38263	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
4691429	4691429	PRJNA888821_P_NODE_41784_length_232_cov_10.811321_g41701_i0	PRJNA888821	41784	232	10.811321	25.08226472	Ancylothrix sp. D3o	2953691	Bacteria	Bacteria	148	3e-41	NR	WP_261224679.1	2953691	g41701	i0	94.7	0.982758620689655	76	4	98.3	0	4	231	84	159	WP_261224679.1 hormogonium polysaccharide biosynthesis glycosyltransferase HpsO [Ancylothrix sp. D3o]	diamond	228	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Ancylothrix	Ancylothrix sp. D3o
6345825	6345825	PRJNA888821_P_NODE_29125_length_274_cov_1.009950_g29043_i0	PRJNA888821	29125	274	1.00995	2.767263	Nostoc	1177	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|1468550239\|emb\|LS992499.1\|	1178	g29043	i0	100	100	274	0	100	0	1	274	74	347	Nostoc commune partial 16S rRNA gene, strain S23	blastn	27400	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
8894494	8894494	PRJNA888821_P_NODE_15347_length_310_cov_6.286920_g15265_i0	PRJNA888821	15347	310	6.28692	19.489452	Synechococcus	1129	Bacteria	Bacteria	150	9.98e-32	NTclustered	gi\|1940477070\|gb\|CP060398.1\|	1353134	g15265	i0	86.525	1.70322580645161	141	13	45	5	173	310	1781223	1781360	Synechococcus sp. CBW1002 chromosome, complete genome	blastn	528	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1002
12341922	12341922	PRJNA888821_P_NODE_28890_length_275_cov_1.009901_g28808_i0	PRJNA888821	28890	275	1.009901	2.77722775	Macrochaete psychrophila	1844959	Bacteria	Bacteria	448	2.7599999999999995e-121	NTclustered	gi\|1026261016\|gb\|KT336439.2\|	1781141	g28808	i0	96.992	272.68	266	8	97	0	2	267	2107	2372	Macrochaete psychrophila CCALA 32 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	74987	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete psychrophila
13616901	13616901	PRJNA888821_P_NODE_611_length_650_cov_2.305026_g543_i0	PRJNA888821	611	650	2.305026	14.982669	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	896	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g543	i0	93.543	97.0538461538462	604	36	93	3	49	650	1614	2216	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	63085	896	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19989139	19989139	PRJNA888821_P_NODE_13096_length_310_cov_8.004219_g13014_i0	PRJNA888821	13096	310	8.004219	24.8130789	Rivularia sp. PCC 7116	373994	Bacteria	Bacteria	169	2.7599999999999997e-37	NTclustered	gi\|427368660\|gb\|CP003549.1\|	373994	g13014	i0	75.949	3.0258064516129	316	62	100	8	1	310	2029607	2029914	Rivularia sp. PCC 7116, complete genome	blastn	938	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. PCC 7116
19989216	19989216	PRJNA888821_P_NODE_17696_length_310_cov_4.641350_g17614_i0	PRJNA888821	17696	310	4.64135	14.388185	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	272	2.04e-68	NTclustered	gi\|225696216\|gb\|FJ805883.1\|	259957	g17614	i0	99.333	149.187096774194	150	1	97	0	161	310	2472	2621	Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	46248	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19989595	19989595	PRJNA888821_P_NODE_39416_length_241_cov_0.916667_g39333_i0	PRJNA888821	39416	241	0.916667	2.20916747	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	394	3.13e-105	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g39333	i0	96.639	220.286307053942	238	7	99	1	4	241	1857892	1857656	Calothrix sp. PCC 7716 DNA, complete genome	blastn	53089	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
22539504	22539504	PRJNA888821_P_NODE_23838_length_298_cov_8.520000_g23756_i0	PRJNA888821	23838	298	8.52	25.3896	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	433	8.47e-117	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g23756	i0	93.471	152.503355704698	291	19	98	0	1	291	1646	1936	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	45446	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23815400	23815400	PRJNA888821_P_NODE_579_length_663_cov_5.632203_g512_i0	PRJNA888821	579	663	5.632203	37.34150589	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1035	0	NTclustered	gi\|225696221\|gb\|FJ805888.1\|	259957	g512	i0	94.872	130.21568627451	663	32	100	2	1	663	2230	2890	Uncultured Chroococcidiopsis sp. clone NA2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	86333	1035	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
26802215	26802215	PRJNA888821_P_NODE_33021_length_257_cov_7.722826_g32938_i0	PRJNA888821	33021	257	7.722826	19.84766282	Cyanobacteria bacterium TGS_CYA1	2835643	Bacteria	Bacteria	135	7.739999999999998e-35	NR	MCW5822155.1	2835643	g32938	i0	82.4	0.992217898832685	85	15	99.2	0	256	2	546	630	MCW5822155.1 S-layer homology domain-containing protein [Cyanobacteria bacterium TGS_CYA1]	diamond	255	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium TGS_CYA1
27340092	27340092	PRJNA888821_P_NODE_47523_length_213_cov_6.500000_g47440_i0	PRJNA888821	47523	213	6.5	13.845	Cyanobacteria bacterium TGS_CYA1	2835643	Bacteria	Bacteria	81.3	6.3e-16	NR	MCW5823504.1	2835643	g47440	i0	54.7	0.901408450704225	64	29	90.1	0	21	212	30	93	MCW5823504.1 deoxyribodipyrimidine photo-lyase [Cyanobacteria bacterium TGS_CYA1]	diamond	192	81.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium TGS_CYA1
27876720	27876720	PRJNA888821_P_NODE_29405_length_272_cov_10.864322_g29323_i0	PRJNA888821	29405	272	10.864322	29.55095584	Microcystis aeruginosa	1126	Bacteria	Bacteria	79.3	4.8e-16	NR	WP_216843270.1	1126	g29323	i0	49.5	1.00367647058824	91	41	99.3	2	2	271	13	99	WP_216843270.1 hypothetical protein [Microcystis aeruginosa]	diamond	273	79.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
28223869	28223869	PRJNA888821_P_NODE_14606_length_310_cov_6.852321_g14524_i0	PRJNA888821	14606	310	6.852321	21.2421951	Cyanobacteria bacterium TGS_CYA1	2835643	Bacteria	Bacteria	89	8.43e-20	NR	MCW5823772.1	2835643	g14524	i0	83.7	0.474193548387097	49	8	47.4	0	162	308	4	52	MCW5823772.1 hypothetical protein [Cyanobacteria bacterium TGS_CYA1]	diamond	147	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium TGS_CYA1
28381919	28381919	PRJNA888821_P_NODE_31926_length_262_cov_1.238095_g31843_i0	PRJNA888821	31926	262	1.238095	3.2438089	Moorena sp. SIO2B7	2607823	Bacteria	Bacteria	72	2.52e-13	NR	NES82709.1	2607823	g31843	i0	58.1	1.85496183206107	62	26	71	0	75	260	7	68	NES82709.1 phycobiliprotein lyase [Moorena sp. SIO2B7]	diamond	486	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena sp. SIO2B7
28571315	28571315	PRJNA888821_P_NODE_25307_length_291_cov_4.100917_g25225_i0	PRJNA888821	25307	291	4.100917	11.93366847	Cyanobacteria bacterium SZAS LIN-3	2807732	Bacteria	Bacteria	108	5.08e-25	NR	MBS1991455.1	2807732	g25225	i0	46.5	1.30927835051546	127	38	100	1	291	1	604	730	MBS1991455.1 M1 family metallopeptidase [Cyanobacteria bacterium SZAS LIN-3]	diamond	381	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-3
28855351	28855351	PRJNA888821_P_NODE_28688_length_275_cov_13.663366_g28606_i0	PRJNA888821	28688	275	13.663366	37.5742565	Dolichospermum sp.	2720786	Bacteria	Bacteria	77.8	2.52e-14	NR	MFN6157896.1	2720786	g28606	i0	47.3	3.97090909090909	91	48	99.3	0	275	3	444	534	MFN6157896.1 RNA-binding domain-containing protein [Dolichospermum sp.]	diamond	1092	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp.
29297607	29297607	PRJNA888821_P_NODE_19469_length_310_cov_3.092827_g19387_i0	PRJNA888821	19469	310	3.092827	9.5877637	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	90.1	2.1e-19	NR	MBS2000231.1	2807734	g19387	i0	87.8	0.474193548387097	49	6	47.4	0	149	3	1	49	MBS2000231.1 sigma-70 family RNA polymerase sigma factor [Cyanobacteria bacterium SZAS LIN-5]	diamond	147	90.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5
29423670	29423670	PRJNA888821_P_NODE_43469_length_226_cov_18.320261_g43386_i0	PRJNA888821	43469	226	18.320261	41.40378986	Chroococcus sp. CMT-3BRIN-NPC107	2499659	Bacteria	Bacteria	103	1.71e-24	NR	MBW4665059.1	2499659	g43386	i0	84.5	0.769911504424779	58	9	77	0	1	174	274	331	MBW4665059.1 DUF11 domain-containing protein [Chroococcus sp. CMT-3BRIN-NPC107]	diamond	174	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. CMT-3BRIN-NPC107
29865946	29865946	PRJNA888821_P_NODE_31651_length_263_cov_3.442105_g31568_i0	PRJNA888821	31651	263	3.442105	9.05273615	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	181	1.7099999999999994e-54	NR	HEY9683299.1	3088181	g31568	i0	100	0.992395437262357	87	0	99.2	0	261	1	182	268	HEY9683299.1 glutamate racemase [Oculatellaceae cyanobacterium]	diamond	261	181	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30403452	30403452	PRJNA888821_P_NODE_13653_length_310_cov_7.578059_g13571_i0	PRJNA888821	13653	310	7.578059	23.4919829	Cyanobacteria bacterium TGS_CYA1	2835643	Bacteria	Bacteria	77.4	4.4e-14	NR	MCW5822109.1	2835643	g13571	i0	76	0.483870967741935	50	12	48.4	0	2	151	321	370	MCW5822109.1 GGDEF domain-containing protein [Cyanobacteria bacterium TGS_CYA1]	diamond	150	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium TGS_CYA1
31445952	31445952	PRJNA888821_P_NODE_23196_length_305_cov_9.693966_g23114_i0	PRJNA888821	23196	305	9.693966	29.5665963	Cyanobacteria bacterium TGS_CYA1	2835643	Bacteria	Bacteria	102	7.619999999999999e-23	NR	MCW5822198.1	2835643	g23114	i0	100	0.481967213114754	49	0	48.2	0	304	158	364	412	MCW5822198.1 CoA transferase [Cyanobacteria bacterium TGS_CYA1]	diamond	147	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium TGS_CYA1
31477719	31477719	PRJNA888821_P_NODE_13876_length_310_cov_7.417722_g13794_i0	PRJNA888821	13876	310	7.417722	22.9949382	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	66.2	4.5e-10	NR	WP_105217807.1	2859516	g13794	i0	61.2	0.474193548387097	49	19	47.4	0	148	2	336	384	WP_105217807.1 ATP-binding protein [Gloeocapsopsis dulcis]	diamond	147	66.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
31485663	31485663	PRJNA888821_P_NODE_46476_length_216_cov_8.699301_g46393_i0	PRJNA888821	46476	216	8.699301	18.79049016	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	157	2.3e-45	NR	WP_208346607.1	1550245	g46393	i0	100	1.97222222222222	71	0	98.6	0	215	3	181	251	WP_208346607.1 ABC transporter substrate-binding protein, partial [Aetokthonos hydrillicola]	diamond	426	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Aetokthonos	Aetokthonos hydrillicola
31635642	31635642	PRJNA888821_P_NODE_37416_length_245_cov_3.744186_g37333_i0	PRJNA888821	37416	245	3.744186	9.1732557	Cyanobacteria bacterium P01_H01_bin.58	3023321	Bacteria	Bacteria	46.6	0.00171	NR	MEM0979816.1	3023321	g37333	i0	37	0.893877551020408	73	46	89.4	0	3	221	170	242	MEM0979816.1 PAS domain S-box protein [Cyanobacteria bacterium P01_H01_bin.58]	diamond	219	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.58
32078580	32078580	PRJNA888821_P_NODE_45778_length_218_cov_13.337931_g45695_i0	PRJNA888821	45778	218	13.337931	29.07668958	Cyanobacteria bacterium J06558_2	3023133	Bacteria	Bacteria	56.2	4.7e-7	NR	MEL7408545.1	3023133	g45695	i0	47.1	1.91284403669725	68	33	89.4	2	204	10	12	79	MEL7408545.1 COR domain-containing protein [Cyanobacteria bacterium J06558_2]	diamond	417	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06558_2
32426700	32426700	PRJNA888821_P_NODE_31719_length_262_cov_19.317460_g31636_i0	PRJNA888821	31719	262	19.31746	50.6117452	Scytonema hofmannii	34078	Bacteria	Bacteria	52	2.2e-5	NR	WP_017746967.1	34078	g31636	i0	38	1.14503816793893	100	47	97.3	3	255	1	59	158	WP_017746967.1 hypothetical protein [Scytonema hofmannii]	diamond	300	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema hofmannii
32426704	32426704	PRJNA888821_P_NODE_38599_length_242_cov_11.615385_g38516_i0	PRJNA888821	38599	242	11.615385	28.1092317	Thermosynechococcus vestitus BP-1	197221	Bacteria	Bacteria	70.5	6.03e-12	NR	BAC09038.1	197221	g38516	i0	79.5	3.47107438016529	39	8	48.3	0	94	210	311	349	BAC09038.1 tll1486 [Thermosynechococcus vestitus BP-1]	diamond	840	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus vestitus

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