metadata: contig_metadata: 19 rows where bioproject = "PRJNA637219" and tax_clade = "Cyanobacteriota/Melainabacteria group"

19 rows where bioproject = "PRJNA637219" 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
2430275	2430275	PRJNA637219_S_NODE_9442_length_174_cov_0.936000_g9397_i0	PRJNA637219	9442	174	0.936	1.62864	Nodosilinea	1120752	Bacteria	Bacteria	316	4.7e-82	NTclustered	gi\|1890430064\|gb\|MT885329.1\|	1123966	g9397	i0	99.425	147.632183908046	174	1	100	0	1	174	2159	1986	Nodosilinea epilithica strain Prim-5-5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25688	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea epilithica
3706688	3706688	PRJNA637219_S_NODE_3243_length_261_cov_2.094340_g3198_i0	PRJNA637219	3243	261	2.09434	5.4662274	Coleofasciculaceae	1892251	Bacteria	Bacteria	449	7.22e-122	NTclustered	gi\|146740643\|emb\|AM709630.1\|	118168	g3198	i0	97.701	168.045977011494	261	6	100	0	1	261	4177	4437	Microcoleus chthonoplastes PCC 7420 partial ribosomal RNA operon, strain PCC 7420	blastn	43860	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
4436581	4436581	PRJNA637219_S_NODE_844_length_459_cov_2.524390_g799_i0	PRJNA637219	844	459	2.52439	11.5869501	Coleofasciculus chthonoplastes	64178	Bacteria	Bacteria	675	0	NTclustered	gi\|146740643\|emb\|AM709630.1\|	118168	g799	i0	93.275	138.788671023965	461	25	100	5	1	459	2498	2954	Microcoleus chthonoplastes PCC 7420 partial ribosomal RNA operon, strain PCC 7420	blastn	63704	675	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
6258721	6258721	PRJNA637219_S_NODE_8705_length_179_cov_1.623077_g8660_i0	PRJNA637219	8705	179	1.623077	2.90530783	Microcoleus	44471	Bacteria	Bacteria	326	8.09e-85	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g8660	i0	99.441	199.826815642458	179	1	100	0	1	179	103492	103314	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	35769	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
8262054	8262054	PRJNA637219_S_NODE_4707_length_225_cov_1.340909_g4662_i0	PRJNA637219	4707	225	1.340909	3.01704525	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	303	5e-78	NTclustered	gi\|225696257\|gb\|FJ805924.1\|	259957	g4662	i0	91.111	124.048888888889	225	19	99	1	1	224	1916	1692	Uncultured Chroococcidiopsis sp. clone AS2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27911	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12088212	12088212	PRJNA637219_S_NODE_15910_length_162_cov_0.902655_g15865_i0	PRJNA637219	15910	162	0.902655	1.4623011	Microcoleus vaginatus	119532	Bacteria	Bacteria	156	9.99e-34	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g15865	i0	87.879	2.44444444444444	132	16	81	0	31	162	3083365	3083496	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	396	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
12634111	12634111	PRJNA637219_S_NODE_2310_length_300_cov_2.067729_g2265_i0	PRJNA637219	2310	300	2.067729	6.203187	Microcoleus	44471	Bacteria	Bacteria	477	3.8899999999999985e-130	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g2265	i0	95.349	132.273333333333	301	12	100	2	1	300	132578	132279	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	39682	477	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
13363018	13363018	PRJNA637219_S_NODE_551_length_537_cov_4.081967_g506_i0	PRJNA637219	551	537	4.081967	21.92016279	Oculatella crustae-formantes	2739055	Bacteria	Bacteria	664	0	NTclustered	gi\|1713066357\|gb\|MN243147.1\|	2599945	g506	i0	90.196	170.378026070763	510	48	95	2	1	510	2451	1944	Oculatella crustae-formantes PJ S28 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	91493	664	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella crustae-formantes
13908997	13908997	PRJNA637219_S_NODE_12971_length_165_cov_0.879310_g12926_i0	PRJNA637219	12971	165	0.87931	1.4508615	Microcoleus	44471	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g12926	i0	100	135.4	165	0	100	0	1	165	3022	3186	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22341	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13909014	13909014	PRJNA637219_S_NODE_3991_length_240_cov_1.712042_g3946_i0	PRJNA637219	3991	240	1.712042	4.1089008	Fischerella	1190	Bacteria	Bacteria	363	8.78e-96	NTclustered	gi\|2314726996\|dbj\|AP024677.1\|	1191	g3946	i0	94.492	188.7375	236	11	98	2	7	240	50928	50693	MAG: Fischerella sp. KatS3mg066 DNA, complete genome	blastn	45297	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp.
15911669	15911669	PRJNA637219_S_NODE_2653_length_284_cov_0.940426_g2608_i0	PRJNA637219	2653	284	0.940426	2.67080984	Thermoleptolyngbya oregonensis	2303529	Bacteria	Bacteria	403	6.28e-108	NTclustered	gi\|2592622306\|gb\|CP053540.1\|	2547457	g2608	i0	92.254	173.665492957746	284	22	100	0	1	284	311946	312229	Thermoleptolyngbya oregonensis NK1-22 chromosome, complete genome	blastn	49321	403	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
17186835	17186835	PRJNA637219_S_NODE_9654_length_172_cov_2.097561_g9609_i0	PRJNA637219	9654	172	2.097561	3.60780492	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	274	2.83e-69	NTclustered	gi\|225696213\|gb\|FJ805880.1\|	259957	g9609	i0	96.386	108.470930232558	166	6	97	0	5	170	3063	2898	Uncultured Chroococcidiopsis sp. clone A3_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	18657	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20281504	20281504	PRJNA637219_S_NODE_476_length_562_cov_5.508772_g432_i0	PRJNA637219	476	562	5.508772	30.95929864	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	296	4.899999999999999e-100	NR	MBX9724270.1	2364082	g432	i0	88.8	0.859430604982206	161	18	85.9	0	561	79	10	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	483	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
22285940	22285940	PRJNA637219_S_NODE_5398_length_214_cov_1.357576_g5353_i0	PRJNA637219	5398	214	1.357576	2.90521264	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	294	2.8400000000000003e-75	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g5353	i0	91.589	68.3831775700935	214	17	100	1	1	214	5559844	5559632	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	14634	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
28628671	28628671	PRJNA637219_S_NODE_12907_length_165_cov_0.879310_g12862_i0	PRJNA637219	12907	165	0.87931	1.4508615	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	74.7	3.09e-14	NR	WP_148298024.1	927677	g12862	i0	77.8	0.818181818181818	45	10	81.8	0	29	163	1	45	WP_148298024.1 hypothetical protein [Synechocystis sp. PCC 7509]	diamond	135	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
28912340	28912340	PRJNA637219_S_NODE_14968_length_163_cov_0.894737_g14923_i0	PRJNA637219	14968	163	0.894737	1.45842131	Microcoleaceae cyanobacterium UBA11344	2055792	Bacteria	Bacteria	45.8	4.51e-4	NR	HAT15612.1	2055792	g14923	i0	76	0.460122699386503	25	6	46	0	162	88	107	131	HAT15612.1 serine hydrolase [Microcoleaceae cyanobacterium UBA11344]	diamond	75	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae		Microcoleaceae cyanobacterium UBA11344
29587833	29587833	PRJNA637219_S_NODE_3470_length_254_cov_1.785366_g3425_i0	PRJNA637219	3470	254	1.785366	4.53482964	Bacteria	2	Bacteria	Bacteria	114	3.73e-28	NR	MEO1636501.1	3023190	g3425	i0	66.3	18.6259842519685	83	28	98	0	254	6	189	271	MEO1636501.1 alkene reductase [Cyanobacteria bacterium J06631_9]	diamond	4731	115	0.991304347826087	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06631_9
29923139	29923139	PRJNA637219_S_NODE_15971_length_162_cov_0.902655_g15926_i0	PRJNA637219	15971	162	0.902655	1.4623011	Microcoleus sp. EPA2	2841654	Bacteria	Bacteria	105	1.85e-25	NR	WP_341731641.1	2841654	g15926	i0	88.7	9.81481481481481	53	6	98.1	0	2	160	8	60	WP_341731641.1 transposase [Microcoleus sp. EPA2]	diamond	1590	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. EPA2
32294380	32294380	PRJNA637219_S_NODE_7339_length_191_cov_1.380282_g7294_i0	PRJNA637219	7339	191	1.380282	2.63633862	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	60.5	1.27e-9	NR	MBX9722668.1	2364082	g7294	i0	66.7	1.49214659685864	48	16	75.4	0	189	46	89	136	MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	285	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium

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