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

18 rows where analysis = "diamond", bioproject = "PRJNA1104180" 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
16789512	16789512	PRJNA1104180_P_NODE_22434_length_247_cov_1.442529_g22291_i0	PRJNA1104180	22434	247	1.442529	3.56304663	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	119	3.02e-30	NR	HCF26950.1	2055787	g22291	i0	85.4	0.995951417004049	82	12	99.6	0	246	1	125	206	HCF26950.1 hypothetical protein [Cyanobacteria bacterium UBA11049]	diamond	246	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
23164599	23164599	PRJNA1104180_P_NODE_17799_length_262_cov_1.629630_g17657_i0	PRJNA1104180	17799	262	1.62963	4.2696306	Tychonema sp. LEGE	3100380	Bacteria	Bacteria	128	2.48e-33	NR	WP_228050064.1	1828663	g17657	i0	92	1.99236641221374	87	7	99.6	0	1	261	165	251	WP_228050064.1 RNA-guided endonuclease InsQ/TnpB family protein [Tychonema sp. LEGE 06208]	diamond	522	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Tychonema	Tychonema sp. LEGE 06208
26624474	26624474	PRJNA1104180_P_NODE_19001_length_256_cov_1.683060_g18859_i0	PRJNA1104180	19001	256	1.68306	4.3086336	Chroococcus sp. CMT-3BRIN-NPC107	2499659	Bacteria	Bacteria	60.1	1.85e-8	NR	MBW4663574.1	2499659	g18859	i0	90.3	0.36328125	31	3	36.3	0	1	93	209	239	MBW4663574.1 HpsJ family protein [Chroococcus sp. CMT-3BRIN-NPC107]	diamond	93	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. CMT-3BRIN-NPC107
26846446	26846446	PRJNA1104180_P_NODE_22841_length_247_cov_0.885057_g22698_i0	PRJNA1104180	22841	247	0.885057	2.18609079	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	157	7.429999999999999e-43	NR	WP_084610772.1	927677	g22698	i0	89	1.9919028340081	82	9	99.6	0	1	246	536	617	WP_084610772.1 ATP-dependent RecD-like DNA helicase [Synechocystis sp. PCC 7509]	diamond	492	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
26909535	26909535	PRJNA1104180_P_NODE_20122_length_251_cov_1.073034_g19979_i0	PRJNA1104180	20122	251	1.073034	2.69331534	Cyanobacteria bacterium 0813	2835650	Bacteria	Bacteria	109	2.74e-26	NR	MBW3584590.1	2835650	g19979	i0	95	0.717131474103586	60	3	71.7	0	2	181	194	253	MBW3584590.1 glycosyltransferase family 4 protein [Cyanobacteria bacterium 0813]	diamond	180	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium 0813
27153370	27153370	PRJNA1104180_P_NODE_20342_length_251_cov_0.865169_g20199_i0	PRJNA1104180	20342	251	0.865169	2.17157419	Cyanophyceae	3028117	Bacteria	Bacteria	113	1.9800000000000003e-27	NR	WP_045054445.1	1827278	g20199	i0	67.5	1.9840637450199201	83	27	99.2	0	251	3	109	191	WP_045054445.1 MlaD family protein [Aliterella atlantica]	diamond	498	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
27225554	27225554	PRJNA1104180_P_NODE_24383_length_244_cov_0.900585_g24240_i0	PRJNA1104180	24383	244	0.900585	2.1974274	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	90.9	2.42e-21	NR	WP_340520919.1	2705319	g24240	i0	97.6	0.504098360655738	41	1	50.4	0	244	122	83	123	WP_340520919.1 VOC family protein [Microcoleus anatoxicus]	diamond	123	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
27343723	27343723	PRJNA1104180_P_NODE_26123_length_241_cov_1.625000_g25980_i0	PRJNA1104180	26123	241	1.625	3.91625	Pleurocapsales	52604	Bacteria	Bacteria	92.8	8.79e-20	NR	MDJ0746164.1	3036636	g25980	i0	56.3	3.85892116182573	80	33	97.1	1	235	2	380	459	MDJ0746164.1 CHASE2 domain-containing protein [Xenococcaceae cyanobacterium MO_167.B27]	diamond	930	93.2	0.995708154506438	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Xenococcaceae		Xenococcaceae cyanobacterium MO_167.B27
27888856	27888856	PRJNA1104180_P_NODE_22105_length_248_cov_0.880000_g21962_i0	PRJNA1104180	22105	248	0.88	2.1824	Aliterella atlantica	1827278	Bacteria	Bacteria	155	1.87e-44	NR	WP_045052897.1	1827278	g21962	i0	96.3	0.991935483870968	82	3	99.2	0	246	1	225	306	WP_045052897.1 DNA polymerase III subunit delta [Aliterella atlantica]	diamond	246	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
28173020	28173020	PRJNA1104180_P_NODE_20846_length_250_cov_0.870056_g20703_i0	PRJNA1104180	20846	250	0.870056	2.17514	Chroococcus sp. FPU1	1974212	Bacteria	Bacteria	159	7.54e-45	NR	WP_206815906.1	1974212	g20703	i0	96.3	0.984	82	3	98.4	0	248	3	247	328	WP_206815906.1 ScyD/ScyE family protein [Chroococcus sp. FPU101]	diamond	246	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. FPU101
28994339	28994339	PRJNA1104180_P_NODE_19628_length_253_cov_1.688889_g19485_i0	PRJNA1104180	19628	253	1.688889	4.27288917	Microcoleus sp. SU_5_3	2720482	Bacteria	Bacteria	50.4	7.89e-6	NR	NJK66883.1	2720482	g19485	i0	77.4	0.367588932806324	31	7	36.8	0	228	136	17	47	NJK66883.1 hypothetical protein [Microcoleus sp. SU_5_3]	diamond	93	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. SU_5_3
29846594	29846594	PRJNA1104180_P_NODE_24451_length_244_cov_0.900585_g24308_i0	PRJNA1104180	24451	244	0.900585	2.1974274	Aliterella atlantica	1827278	Bacteria	Bacteria	147	5.62e-41	NR	WP_045055570.1	1827278	g24308	i0	97.5	0.995901639344262	81	2	99.6	0	244	2	208	288	WP_045055570.1 quinone-dependent dihydroorotate dehydrogenase [Aliterella atlantica]	diamond	243	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
30352601	30352601	PRJNA1104180_P_NODE_26512_length_241_cov_0.916667_g26369_i0	PRJNA1104180	26512	241	0.916667	2.20916747	Dendronalium sp. ChiSLP	3075381	Bacteria	Bacteria	53.9	4.34e-6	NR	WP_322663687.1	3075381	g26369	i0	44.4	2.53941908713693	72	33	89.6	2	241	26	2005	2069	WP_322663687.1 DUF4347 domain-containing protein [Dendronalium sp. ChiSLP03b]	diamond	612	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Dendronalium	Dendronalium sp. ChiSLP03b
30415590	30415590	PRJNA1104180_P_NODE_23913_length_245_cov_0.895349_g23770_i0	PRJNA1104180	23913	245	0.895349	2.19360505	Microcoleus sp. FACHB-45	2692822	Bacteria	Bacteria	153	1.34e-45	NR	MBD2010724.1	2692822	g23770	i0	95	0.979591836734694	80	4	98	0	245	6	38	117	MBD2010724.1 helix-turn-helix domain-containing protein [Microcoleus sp. FACHB-45]	diamond	240	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-45
31964169	31964169	PRJNA1104180_P_NODE_21658_length_249_cov_0.875000_g21515_i0	PRJNA1104180	21658	249	0.875	2.17875	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	143	1.38e-37	NR	WP_028954495.1	927677	g21515	i0	92.7	0.987951807228916	82	6	98.8	0	3	248	509	590	WP_028954495.1 CHAT domain-containing protein [Synechocystis sp. PCC 7509]	diamond	246	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
32027606	32027606	PRJNA1104180_P_NODE_14218_length_282_cov_1.244019_g14076_i0	PRJNA1104180	14218	282	1.244019	3.50813358	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	140	7.02e-39	NR	MBY0402270.1	2847862	g14076	i0	68.9	0.957446808510638	90	28	95.7	0	7	276	26	115	MBY0402270.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	270	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32027609	32027609	PRJNA1104180_P_NODE_22618_length_247_cov_0.885057_g22475_i0	PRJNA1104180	22618	247	0.885057	2.18609079	Chroococcidiopsis sp. [FACHB-1243]	2692781	Bacteria	Bacteria	158	2.37e-46	NR	WP_192161982.1	2692781	g22475	i0	100	0.983805668016194	81	0	98.4	0	3	245	132	212	WP_192161982.1 SDR family NAD(P)-dependent oxidoreductase [Chroococcidiopsis sp. [FACHB-1243]]	diamond	243	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. [FACHB-1243]
32808607	32808607	PRJNA1104180_P_NODE_19640_length_253_cov_1.605556_g19497_i0	PRJNA1104180	19640	253	1.605556	4.06205668	Coleofasciculus	669368	Bacteria	Bacteria	75.9	8.75e-14	NR	MEQ8969659.1	3069522	g19497	i0	60.3	2.28853754940711	63	25	74.7	0	194	6	10	72	MEQ8969659.1 hypothetical protein [Coleofasciculus sp. C1-SOL-03]	diamond	579	76.6	0.990861618798956	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. C1-SOL-03

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