metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA906294" and tax_clade = "Cyanobacteriota/Melainabacteria group"

18 rows where analysis = "diamond", bioproject = "PRJNA906294" 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
8901399	8901399	PRJNA906294_P_NODE_192147_length_263_cov_1.421053_g188031_i0	PRJNA906294	192147	263	1.421053	3.73736939	Oculatellaceae cyanobacterium Prado106	2929566	Bacteria	Bacteria	79	6.79e-15	NR	MCU0565255.1	2929566	g188031	i0	65.5	4.41444866920152	55	19	62.7	0	262	98	335	389	MCU0565255.1 class I SAM-dependent rRNA methyltransferase [Oculatellaceae cyanobacterium Prado106]	diamond	1161	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium Prado106
25111357	25111357	PRJNA906294_P_NODE_103100_length_406_cov_1.543544_g98985_i0	PRJNA906294	103100	406	1.543544	6.26678864	Cyanophyceae	3028117	Bacteria	Bacteria	107	6.36e-25	NR	WP_012164710.1	155978	g98985	i0	51	15.487684729064	100	49	73.9	0	105	404	2	101	WP_012164710.1 globin family protein [Acaryochloris marina]	diamond	6288	108	0.990740740740741	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina
26707454	26707454	PRJNA906294_P_NODE_163741_length_294_cov_0.846154_g159625_i0	PRJNA906294	163741	294	0.846154	2.48769276	Nostoc cyanobionts	3123326	Bacteria	Bacteria	45.1	0.00106	NR	WP_181154131.1	3123326	g159625	i0	38.1	0.642857142857143	63	39	64.3	0	249	61	2	64	WP_181154131.1 MULTISPECIES: hypothetical protein [Nostoc cyanobionts]	diamond	189	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc
26960886	26960886	PRJNA906294_P_NODE_208622_length_249_cov_0.863636_g204506_i0	PRJNA906294	208622	249	0.863636	2.15045364	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	60.5	2.19e-8	NR	MBY0358054.1	2364082	g204506	i0	42	1.90361445783133	81	39	89.2	2	11	232	218	297	MBY0358054.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	474	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27277351	27277351	PRJNA906294_P_NODE_84543_length_472_cov_1.814536_g80429_i0	PRJNA906294	84543	472	1.814536	8.56460992	Microcystis aeruginosa	1126	Bacteria	Bacteria	47	0.0119	NR	WP_061433356.1	1126	g80429	i0	27.5	0.508474576271186	80	51	46.4	2	2	220	325	404	WP_061433356.1 hypothetical protein [Microcystis aeruginosa]	diamond	240	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
27340538	27340538	PRJNA906294_P_NODE_143583_length_321_cov_1.205645_g139467_i0	PRJNA906294	143583	321	1.205645	3.87012045	Leptolyngbya sp. FACHB-36	2692808	Bacteria	Bacteria	43.5	0.0482	NR	WP_190341097.1	2692808	g139467	i0	35.5	0.710280373831776	76	48	71	1	319	92	499	573	WP_190341097.1 amylo-alpha-1,6-glucosidase [Leptolyngbya sp. FACHB-36]	diamond	228	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-36
27498428	27498428	PRJNA906294_P_NODE_182023_length_273_cov_1.630000_g177907_i0	PRJNA906294	182023	273	1.63	4.4499	Timaviella obliquedivisa	2303516	Bacteria	Bacteria	70.1	1.03e-11	NR	MBW4516100.1	2057768	g177907	i0	68	4.75824175824176	50	16	54.9	0	154	5	1	50	MBW4516100.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Timaviella obliquedivisa GSE-PSE-MK23-08B]	diamond	1299	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Timaviella	Timaviella obliquedivisa
27845496	27845496	PRJNA906294_P_NODE_225424_length_243_cov_0.894118_g221308_i0	PRJNA906294	225424	243	0.894118	2.17270674	Scytonematopsis contorta	1049027	Bacteria	Bacteria	42.7	0.0371	NR	MBW4512232.1	1049028	g221308	i0	33.9	0.691358024691358	56	37	69.1	0	211	44	226	281	MBW4512232.1 HAMP domain-containing protein [Scytonematopsis contorta HA4267-MV1]	diamond	168	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonematopsis	Scytonematopsis contorta
27877188	27877188	PRJNA906294_P_NODE_172305_length_284_cov_1.080569_g168189_i0	PRJNA906294	172305	284	1.080569	3.06881596	Mastigocoleus testarum	996925	Bacteria	Bacteria	46.6	0.00272	NR	WP_027842672.1	996925	g168189	i0	35.9	0.823943661971831	78	41	72.9	4	218	12	108	185	WP_027842672.1 hybrid sensor histidine kinase/response regulator [Mastigocoleus testarum]	diamond	234	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Mastigocoleus	Mastigocoleus testarum
29171903	29171903	PRJNA906294_P_NODE_213269_length_247_cov_0.873563_g209153_i0	PRJNA906294	213269	247	0.873563	2.15770061	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	75.5	8.16e-14	NR	MBT9548240.1	2762020	g209153	i0	48.6	0.850202429149798	70	36	85	0	34	243	97	166	MBT9548240.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	210	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29234974	29234974	PRJNA906294_P_NODE_221569_length_244_cov_0.900585_g217453_i0	PRJNA906294	221569	244	0.900585	2.1974274	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	94	7.02e-21	NR	WP_190772632.1	2650499	g217453	i0	66.2	0.799180327868853	65	20	79.9	1	200	6	183	245	WP_190772632.1 MULTISPECIES: vitamin K epoxide reductase family protein [unclassified Leptolyngbya]	diamond	195	94	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
29273811	29273811	PRJNA906294_P_NODE_195489_length_260_cov_1.090909_g191373_i0	PRJNA906294	195489	260	1.090909	2.8363634	Bacteria	2	Bacteria	Bacteria	88.2	1.54e-18	NR	MEB3272862.1	54309	g191373	i0	47.6	5.88461538461539	84	44	96.9	0	256	5	203	286	MEB3272862.1 globin family protein [Prochlorothrix sp.]	diamond	1530	88.6	0.99548532731377	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Prochlorotrichales	Prochlorotrichaceae	Prochlorothrix	Prochlorothrix sp.
29550439	29550439	PRJNA906294_P_NODE_136410_length_332_cov_1.864865_g132294_i0	PRJNA906294	136410	332	1.864865	6.1913518	Calothrix sp. PCC 63	1187	Bacteria	Bacteria	47.8	0.00156	NR	WP_015200890.1	1170562	g132294	i0	35.6	0.533132530120482	59	34	53.3	1	154	330	48	102	WP_015200890.1 sterol desaturase family protein [Calothrix sp. PCC 6303]	diamond	177	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
30245733	30245733	PRJNA906294_P_NODE_226432_length_242_cov_1.822485_g222316_i0	PRJNA906294	226432	242	1.822485	4.4104137	Cyanobacteria bacterium J06635_15	3023204	Bacteria	Bacteria	45.4	0.00424	NR	MEO1349849.1	3023204	g222316	i0	41.5	0.65702479338843	53	31	65.7	0	194	36	1575	1627	MEO1349849.1 amino acid adenylation domain-containing protein [Cyanobacteria bacterium J06635_15]	diamond	159	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06635_15
30751126	30751126	PRJNA906294_P_NODE_231554_length_241_cov_0.904762_g227438_i0	PRJNA906294	231554	241	0.904762	2.18047642	Cyanothece sp. SIO2G6	2607797	Bacteria	Bacteria	59.7	7.93e-9	NR	NEQ95228.1	2607797	g227438	i0	39.5	1.07053941908714	86	44	97.1	2	237	4	24	109	NEQ95228.1 GNAT family N-acetyltransferase [Cyanothece sp. SIO2G6]	diamond	258	59.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	Cyanothece sp. SIO2G6
30782624	30782624	PRJNA906294_P_NODE_217654_length_245_cov_2.959302_g213538_i0	PRJNA906294	217654	245	2.959302	7.2502899	Symploca sp. SIO3C6	2607803	Bacteria	Bacteria	43.1	0.0258	NR	NEO30896.1	2607803	g213538	i0	47.6	0.514285714285714	42	22	51.4	0	65	190	1	42	NEO30896.1 hypothetical protein [Symploca sp. SIO3C6]	diamond	126	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Symploca	Symploca sp. SIO3C6
31003871	31003871	PRJNA906294_P_NODE_127994_length_347_cov_1.795620_g123878_i0	PRJNA906294	127994	347	1.79562	6.2308014	Leptolyngbyaceae cyanobacterium LF-bin-369	2804781	Bacteria	Bacteria	47	0.00336	NR	MBC7514876.1	2804781	g123878	i0	51.2	1.52161383285303	43	21	37.2	0	6	134	248	290	MBC7514876.1 S-methyl-5'-thioadenosine phosphorylase [Leptolyngbyaceae cyanobacterium LF-bin-369]	diamond	528	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium LF-bin-369
32585450	32585450	PRJNA906294_P_NODE_219559_length_245_cov_0.883721_g215443_i0	PRJNA906294	219559	245	0.883721	2.16511645	Candidatus Marinamargulisbacteria bacterium SCGC AG-343-D	2933166	Bacteria	Bacteria	43.9	0.0145	NR	RAP29296.1	2184343	g215443	i0	27.6	0.930612244897959	76	47	84.5	2	225	19	298	372	RAP29296.1 hypothetical protein DID78_03985 [Candidatus Marinamargulisbacteria bacterium SCGC AG-343-D04]	diamond	228	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota	Candidatus Marinamargulisbacteria				Candidatus Marinamargulisbacteria bacterium SCGC AG-343-D04

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