metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA942359" 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
9851201	9851201	PRJNA942359_P_NODE_9828_length_282_cov_2.110048_g9713_i0	PRJNA942359	9828	282	2.110048	5.95033536	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	119	6.809999999999998e-32	NR	MBW4637582.1	2839657	g9713	i0	91.9	0.659574468085106	62	5	66	0	89	274	1	62	MBW4637582.1 MgtC/SapB family protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	186	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
28099079	28099079	PRJNA942359_P_NODE_14005_length_252_cov_0.871508_g13890_i0	PRJNA942359	14005	252	0.871508	2.19620016	Microcoleus sp. FACHB-84	2692828	Bacteria	Bacteria	84.7	2.84e-18	NR	MBD1884992.1	2692828	g13890	i0	88.5	0.619047619047619	52	6	61.9	0	6	161	134	185	MBD1884992.1 NADPH-dependent FMN reductase [Microcoleus sp. FACHB-84]	diamond	156	84.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-84
28383276	28383276	PRJNA942359_P_NODE_18746_length_244_cov_0.912281_g18631_i0	PRJNA942359	18746	244	0.912281	2.22596564	Chroococcus sp. FPU1	1974212	Bacteria	Bacteria	164	2.96e-47	NR	WP_206816326.1	1974212	g18631	i0	97.5	1.9672131147541	80	2	98.4	0	3	242	132	211	WP_206816326.1 TRAP transporter substrate-binding protein [Chroococcus sp. FPU101]	diamond	480	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. FPU101
28541394	28541394	PRJNA942359_P_NODE_12087_length_260_cov_1.641711_g11972_i0	PRJNA942359	12087	260	1.641711	4.2684486	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	84.7	2.25e-17	NR	HEY9770621.1	3081323	g11972	i0	86.7	1.03846153846154	45	6	51.9	0	2	136	2	46	HEY9770621.1 pentapeptide repeat-containing protein [Coleofasciculaceae cyanobacterium]	diamond	270	84.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
29456504	29456504	PRJNA942359_P_NODE_17670_length_246_cov_0.901734_g17555_i0	PRJNA942359	17670	246	0.901734	2.21826564	Chroococcidiopsis sp. SAG 2	3088168	Bacteria	Bacteria	107	5.6e-26	NR	WP_317111915.1	171389	g17555	i0	96.2	0.634146341463415	52	2	63.4	0	1	156	241	292	WP_317111915.1 hypothetical protein [Chroococcidiopsis sp. SAG 2025]	diamond	156	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
29747527	29747527	PRJNA942359_P_NODE_17650_length_246_cov_0.901734_g17535_i0	PRJNA942359	17650	246	0.901734	2.21826564	Nostocales	1161	Bacteria	Bacteria	79	1.18e-15	NR	WP_335187563.1	1180	g17535	i0	48.1	6.80487804878049	81	41	97.6	1	245	6	156	236	WP_335187563.1 hypothetical protein [Nostoc sp.]	diamond	1674	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
29867345	29867345	PRJNA942359_P_NODE_9391_length_287_cov_1.172897_g9276_i0	PRJNA942359	9391	287	1.172897	3.36621439	Chroococcidiopsis sp. [FACHB-1243]	2692781	Bacteria	Bacteria	147	1.7699999999999993e-41	NR	WP_192159185.1	2692781	g9276	i0	76.1	0.961672473867596	92	22	96.2	0	11	286	168	259	WP_192159185.1 RNA polymerase sigma-70 factor [Chroococcidiopsis sp. [FACHB-1243]]	diamond	276	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. [FACHB-1243]
29899004	29899004	PRJNA942359_P_NODE_18851_length_244_cov_0.912281_g18736_i0	PRJNA942359	18851	244	0.912281	2.22596564	Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35	2801880	Bacteria	Bacteria	139	8.22e-38	NR	MBV8883031.1	2801880	g18736	i0	86.4	0.995901639344262	81	11	99.6	0	2	244	193	273	MBV8883031.1 hypothetical protein [Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35]	diamond	243	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35
30657115	30657115	PRJNA942359_P_NODE_11993_length_261_cov_1.531915_g11878_i0	PRJNA942359	11993	261	1.531915	3.99829815	Cyanobacteria bacterium J06560_2	3023136	Bacteria	Bacteria	111	3.26e-29	NR	MEL7331043.1	3023136	g11878	i0	79.4	0.724137931034483	63	13	72.4	0	73	261	42	104	MEL7331043.1 hypothetical protein [Cyanobacteria bacterium J06560_2]	diamond	189	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06560_2
30720269	30720269	PRJNA942359_P_NODE_11494_length_266_cov_1.305699_g11379_i0	PRJNA942359	11494	266	1.305699	3.47315934	Richelia sp. CSU_2_1	2720414	Bacteria	Bacteria	91.3	3.06e-22	NR	NJR20848.1	2720414	g11379	i0	95.5	0.496240601503759	44	2	49.6	0	134	3	1	44	NJR20848.1 hypothetical protein [Richelia sp. CSU_2_1]	diamond	132	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. CSU_2_1
30941707	30941707	PRJNA942359_P_NODE_14554_length_251_cov_0.876404_g14439_i0	PRJNA942359	14554	251	0.876404	2.19977404	Leptolyngbya sp. Cla-17	2803751	Bacteria	Bacteria	157	5.25e-44	NR	WP_171576396.1	2803751	g14439	i0	95.2	0.99203187250996006	83	4	99.2	0	251	3	74	156	WP_171576396.1 hypothetical protein [Leptolyngbya sp. Cla-17]	diamond	249	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. Cla-17
31043446	31043446	PRJNA942359_P_NODE_17915_length_245_cov_1.639535_g17800_i0	PRJNA942359	17915	245	1.639535	4.01686075	Cyanophyceae	3028117	Bacteria	Bacteria	62.4	4.24e-9	NR	MBW4558466.1	2835091	g17800	i0	43	1.93469387755102	79	45	96.7	0	2	238	177	255	MBW4558466.1 baseplate J/gp47 family protein [Trichormus sp. ATA11-4-KO1]	diamond	474	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus sp. ATA11-4-KO1
31826710	31826710	PRJNA942359_P_NODE_18757_length_244_cov_0.912281_g18642_i0	PRJNA942359	18757	244	0.912281	2.22596564	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	121	5.97e-33	NR	WP_009632843.1	927677	g18642	i0	88.3	0.94672131147541	77	9	94.7	0	3	233	21	97	WP_009632843.1 type IV pilin-like G/H family protein [Synechocystis sp. PCC 7509]	diamond	231	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
31826712	31826712	PRJNA942359_P_NODE_19257_length_243_cov_0.917647_g19142_i0	PRJNA942359	19257	243	0.917647	2.22988221	Nodosilinea sp. LEGE	2497642	Bacteria	Bacteria	152	1.65e-44	NR	WP_194021978.1	2777970	g19142	i0	91.3	0.987654320987654	80	7	98.8	0	242	3	75	154	WP_194021978.1 SRPBCC family protein [Nodosilinea sp. LEGE 07298]	diamond	240	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. LEGE 07298
32396502	32396502	PRJNA942359_P_NODE_19899_length_242_cov_0.923077_g19784_i0	PRJNA942359	19899	242	0.923077	2.23384634	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	183	8.24e-58	NR	MBW4639045.1	2839657	g19784	i0	98.8	0.991735537190083	80	1	99.2	0	241	2	43	122	MBW4639045.1 anti-sigma regulatory factor [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	240	183	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32523227	32523227	PRJNA942359_P_NODE_12839_length_253_cov_1.705556_g12724_i0	PRJNA942359	12839	253	1.705556	4.31505668	Aetokthonos hydrillicola	1550245	Bacteria	Bacteria	74.7	2.23e-13	NR	WP_208346254.1	1550245	g12724	i0	53.1	2.8695652173913	81	37	96	1	251	9	200	279	WP_208346254.1 hypothetical protein, partial [Aetokthonos hydrillicola]	diamond	726	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Aetokthonos	Aetokthonos hydrillicola
32530040	32530040	PRJNA942359_P_NODE_15939_length_248_cov_1.520000_g15824_i0	PRJNA942359	15939	248	1.52	3.7696	Microcoleus	44471	Bacteria	Bacteria	85.5	1.17e-19	NR	MEP6521113.1	2933971	g15824	i0	75.4	2.06854838709677	57	14	69	0	175	5	14	70	MEP6521113.1 hypothetical protein [Microcoleus vaginatus DQ-U2]	diamond	513	85.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
32774962	32774962	PRJNA942359_P_NODE_11420_length_266_cov_2.937824_g11305_i0	PRJNA942359	11420	266	2.937824	7.81461184	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	129	1.33e-32	NR	MBW4504382.1	1939789	g11305	i0	65.9	3.96992481203007	88	30	99.2	0	265	2	438	525	MBW4504382.1 HEAT repeat domain-containing protein [Scytonema hyalinum WJT4-NPBG1]	diamond	1056	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum

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