metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA606583" and tax_clade = "Cyanobacteriota/Melainabacteria group"

11 rows where analysis = "blastn", bioproject = "PRJNA606583" 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
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
10787784	10787784	PRJNA606583_P_NODE_14129_length_342_cov_10.678689_g13701_i0	PRJNA606583	14129	342	10.678689	36.52111638	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	433	9.88e-117	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g13701	i0	89.474	136.119883040936	342	36	100	0	1	342	3680689	3680348	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	46553	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
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
20985831	20985831	PRJNA606583_P_NODE_1077_length_1089_cov_6.115019_g704_i2	PRJNA606583	1077	1089	6.115019	66.59255691	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1123	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g704	i2	85.403	113.051423324151	1103	137	100	23	1	1089	3681574	3682666	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	123113	1123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
22260602	22260602	PRJNA606583_P_NODE_1018_length_1108_cov_7.783380_g704_i1	PRJNA606583	1018	1108	7.78338	86.2398504	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1133	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g704	i1	85.231	105.532490974729	1124	140	100	24	1	1108	3681553	3682666	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	116930	1133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
22260645	22260645	PRJNA606583_P_NODE_18398_length_284_cov_3.323887_g17969_i0	PRJNA606583	18398	284	3.323887	9.43983908	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	147	1.17e-30	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17969	i0	97.647	55.4964788732394	85	2	30	0	4	88	3680947	3681031	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	15761	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
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

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