metadata: contig_metadata: 19 rows where bioproject = "PRJNA606583", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

19 rows where bioproject = "PRJNA606583", tax_clade = "Cyanobacteriota/Melainabacteria group" 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
4411269	4411269	PRJNA606583_P_NODE_35264_length_171_cov_1.917910_g34835_i0	PRJNA606583	35264	171	1.91791	3.2796261	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	239	1.02e-58	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g34835	i0	91.908	188.210526315789	173	10	99	2	3	171	2152234	2152062	Leptolyngbya sp. 7M chromosome	blastn	32184	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
13337671	13337671	PRJNA606583_P_NODE_22911_length_240_cov_2.014778_g22482_i0	PRJNA606583	22911	240	2.014778	4.8354672	Ancylothrix terrestris	2023235	Bacteria	Bacteria	340	4.11e-89	NTclustered	gi\|2257652262\|gb\|ON803474.1\|	2953716	g22482	i0	92.5	136.3875	240	15	99	2	1	239	2231	1994	Ancylothrix terrestris strain BEA0843B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32733	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Ancylothrix	Ancylothrix terrestris
13337726	13337726	PRJNA606583_P_NODE_32511_length_182_cov_1.606897_g32082_i0	PRJNA606583	32511	182	1.606897	2.92455254	Nostoc sp. C117	3349875	Bacteria	Bacteria	235	1.43e-57	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g32082	i0	90.909	24.1263736263736	176	15	97	1	1	176	6456487	6456313	Nostoc sp. C117 chromosome, complete genome	blastn	4391	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
14612540	14612540	PRJNA606583_P_NODE_25752_length_218_cov_2.104972_g25323_i0	PRJNA606583	25752	218	2.104972	4.58883896	Oculatella lusitanica	2928764	Bacteria	Bacteria	315	2.23e-81	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g25323	i0	92.661	173.798165137615	218	16	100	0	1	218	3524	3307	Oculatella lusitanica LEGE 161147 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	37888	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
15174538	15174538	PRJNA606583_P_NODE_2132_length_842_cov_20.951553_g1845_i0	PRJNA606583	2132	842	20.951553	176.41207626	Gloeocapsopsis	693222	Bacteria	Bacteria	800	0	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g1845	i0	84.185	112.761282660333	841	116	99	16	10	842	3487	2656	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	94945	800	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
23536160	23536160	PRJNA606583_P_NODE_8919_length_451_cov_5.736715_g8497_i0	PRJNA606583	8919	451	5.736715	25.87258465	Aliterella chasmolithica	2739056	Bacteria	Bacteria	767	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g8497	i0	97.339	116.062084257206	451	12	100	0	1	451	1975	2425	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	52344	767	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
25372888	25372888	PRJNA606583_P_NODE_4340_length_637_cov_8.055000_g3970_i0	PRJNA606583	4340	637	8.055	51.31035	Gloeocapsopsis	693222	Bacteria	Bacteria	760	0	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g3970	i0	90.893	95.0847723704867	571	44	89	8	10	575	3487	2920	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	60569	760	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
26731537	26731537	PRJNA606583_P_NODE_31701_length_186_cov_1.046980_g31272_i0	PRJNA606583	31701	186	1.04698	1.9473828	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	93.2	2.03e-20	NR	MBX9692574.1	2847862	g31272	i0	72.6	1	62	17	100	0	186	1	295	356	MBX9692574.1 transposase [Cyanobacteriota bacterium]	diamond	186	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27535682	27535682	PRJNA606583_P_NODE_26283_length_215_cov_1.533708_g25854_i0	PRJNA606583	26283	215	1.533708	3.2974722	Bacillati	1783272	Bacteria	Bacteria	130	6.25e-36	NR	MBA3991952.1	2067977	g25854	i0	80.3	1.98139534883721	71	14	99.1	0	213	1	34	104	MBA3991952.1 hypothetical protein [Cyanobacteria bacterium DS2.3.42]	diamond	426	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium DS2.3.42
27901145	27901145	PRJNA606583_P_NODE_33685_length_177_cov_1.392857_g33256_i0	PRJNA606583	33685	177	1.392857	2.46535689	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	119	2.06e-29	NR	HEY9684282.1	3088181	g33256	i0	94.8	0.983050847457627	58	3	98.3	0	3	176	439	496	HEY9684282.1 type IV secretory system conjugative DNA transfer family protein [Oculatellaceae cyanobacterium]	diamond	174	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28374898	28374898	PRJNA606583_P_NODE_28126_length_204_cov_0.904192_g27697_i0	PRJNA606583	28126	204	0.904192	1.84455168	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	62.4	2.2e-9	NR	HEY9680853.1	3088181	g27697	i0	42.4	0.970588235294118	66	37	95.6	1	199	5	253	318	HEY9680853.1 toprim domain-containing protein [Oculatellaceae cyanobacterium]	diamond	198	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28974968	28974968	PRJNA606583_P_NODE_39248_length_159_cov_1.278689_g38819_i0	PRJNA606583	39248	159	1.278689	2.03311551	Cyanobacteria bacterium DS2.3.42	2067977	Bacteria	Bacteria	75.1	4.43e-14	NR	MBA3992282.1	2067977	g38819	i0	65.4	0.981132075471698	52	17	98.1	1	157	2	206	256	MBA3992282.1 hypothetical protein [Cyanobacteria bacterium DS2.3.42]	diamond	156	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium DS2.3.42
29303729	29303729	PRJNA606583_P_NODE_40489_length_156_cov_0.983193_g40060_i0	PRJNA606583	40489	156	0.983193	1.53378108	Trichormus	264688	Bacteria	Bacteria	103	7.23e-25	NR	MBU6450306.1	2800110	g40060	i0	96.1	6.86538461538461	51	2	98.1	0	3	155	39	89	MBU6450306.1 response regulator [Cyanobacteria bacterium REEB67]	diamond	1071	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium REEB67
29827254	29827254	PRJNA606583_P_NODE_42171_length_152_cov_1.017391_g41742_i0	PRJNA606583	42171	152	1.017391	1.54643432	Cyanobacteria bacterium PR.023	2067979	Bacteria	Bacteria	56.6	1.35e-7	NR	MBA4076233.1	2067979	g41742	i0	58	0.986842105263158	50	19	98.7	2	3	152	9	56	MBA4076233.1 single-stranded-DNA-specific exonuclease RecJ [Cyanobacteria bacterium PR.023]	diamond	150	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
30428076	30428076	PRJNA606583_P_NODE_31073_length_188_cov_2.410596_g30644_i0	PRJNA606583	31073	188	2.410596	4.53192048	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	46.2	1.55e-4	NR	HEY9682146.1	3088181	g30644	i0	74.1	0.430851063829787	27	6	41.5	1	1	78	60	86	HEY9682146.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	81	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30775339	30775339	PRJNA606583_P_NODE_23814_length_233_cov_1.540816_g23385_i0	PRJNA606583	23814	233	1.540816	3.59010128	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	147	3.389999999999999e-42	NR	HEY9757686.1	3088181	g23385	i0	92.1	0.978540772532189	76	6	97.9	0	229	2	143	218	HEY9757686.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	228	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
32071582	32071582	PRJNA606583_P_NODE_32498_length_182_cov_1.613793_g32069_i0	PRJNA606583	32498	182	1.613793	2.93710326	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	100	3.9599999999999997e-23	NR	MBX9692574.1	2847862	g32069	i0	81.7	0.989010989010989	60	11	98.9	0	182	3	234	293	MBX9692574.1 transposase [Cyanobacteriota bacterium]	diamond	180	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32622359	32622359	PRJNA606583_P_NODE_40600_length_155_cov_2.313559_g40171_i0	PRJNA606583	40600	155	2.313559	3.58601645	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	50.4	2.11e-5	NR	OLE96369.1	1805100	g40171	i0	53.8	5.32258064516129	39	18	75.5	0	1	117	223	261	OLE96369.1 MAG: hypothetical protein AUG75_21370 [Cyanobacteria bacterium 13_1_20CM_4_61_6]	diamond	825	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium 13_1_20CM_4_61_6
32672159	32672159	PRJNA606583_P_NODE_39840_length_157_cov_1.950000_g39411_i0	PRJNA606583	39840	157	1.95	3.0615	Cyanobacteria bacterium SZAS LIN-2	2807731	Bacteria	Bacteria	45.8	9.14e-4	NR	MBS1994710.1	2807731	g39411	i0	79.2	0.955414012738854	24	5	45.9	0	155	84	463	486	MBS1994710.1 CHASE3 domain-containing protein [Cyanobacteria bacterium SZAS LIN-2]	diamond	150	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-2

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