metadata: contig_metadata: 22 rows where bioproject = "PRJNA857857" and tax_clade = "Cyanobacteriota/Melainabacteria group"

22 rows where bioproject = "PRJNA857857" 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
3787399	3787399	PRJNA857857_P_NODE_17403_length_376_cov_1.874587_g16955_i0	PRJNA857857	17403	376	1.874587	7.04844712	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	188	8.649999999999998e-55	NR	MBK8190560.1	2692181	g16955	i0	77.4	3.95744680851064	124	28	98.9	0	373	2	239	362	MBK8190560.1 IMP dehydrogenase [Vampirovibrionales bacterium]	diamond	1488	188	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales			Vampirovibrionales bacterium
7222837	7222837	PRJNA857857_P_NODE_11546_length_463_cov_3.248718_g11106_i0	PRJNA857857	11546	463	3.248718	15.04156434	Halotia branconii	1620816	Bacteria	Bacteria	484	3.7399999999999986e-132	NTclustered	gi\|2500982325\|gb\|CP124543.1\|	1539056	g11106	i0	85.653	275.449244060475	467	59	100	7	1	463	1245028	1245490	Halotia branconii CENA392 chromosome, complete genome	blastn	127533	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Halotia	Halotia branconii
8498021	8498021	PRJNA857857_P_NODE_36527_length_251_cov_1.269663_g36078_i0	PRJNA857857	36527	251	1.269663	3.18685413	Nostoc edaphicum	264686	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g36078	i0	100	0.115537848605578	29	0	12	0	143	171	2889485	2889513	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
17422797	17422797	PRJNA857857_P_NODE_1174_length_1275_cov_4.405990_g960_i0	PRJNA857857	1174	1275	4.40599	56.1763725	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1565	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g960	i0	89.061	127.596078431373	1289	103	99	32	1	1274	1628	2893	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	162685	1565	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19971349	19971349	PRJNA857857_P_NODE_18176_length_368_cov_1.888136_g17728_i0	PRJNA857857	18176	368	1.888136	6.94834048	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	348	3.98e-91	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g17728	i0	84.153	96.1711956521739	366	50	98	7	8	368	6832015	6831653	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	35391	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
21246948	21246948	PRJNA857857_P_NODE_19237_length_357_cov_2.936620_g18789_i0	PRJNA857857	19237	357	2.93662	10.4837334	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	405	2.25e-108	NTclustered	gi\|1280084619\|gb\|MF574181.1\|	119533	g18789	i0	91.03	205.588235294118	301	25	84	2	1	300	4873	5172	Scytonema hyalinum rrn type 1 operon, precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, 23S ribosomal RNA, 23S-5S ITS, and 5S ribosomal RNA genes, complete sequence	blastn	73395	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
27687304	27687304	PRJNA857857_P_NODE_8084_length_546_cov_8.794926_g7655_i0	PRJNA857857	8084	546	8.794926	48.02029596	Pleurocapsa sp. PCC 7319	118161	Bacteria	Bacteria	108	2.48e-26	NR	WP_019509207.1	118161	g7655	i0	33.5	1.74725274725275	161	104	87.9	2	484	5	3	161	WP_019509207.1 TerB family tellurite resistance protein [Pleurocapsa sp. PCC 7319]	diamond	954	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7319
28137304	28137304	PRJNA857857_P_NODE_6145_length_627_cov_2.050542_g5725_i0	PRJNA857857	6145	627	2.050542	12.85689834	Bacteria	2	Bacteria	Bacteria	47.4	0.0236	NR	OCR02547.1	1880991	g5725	i0	46.8	1.17224880382775	94	48	44.5	2	536	258	306	398	OCR02547.1 hypothetical protein BCD67_01285 [Oscillatoriales cyanobacterium USR001]	diamond	735	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium USR001
28191838	28191838	PRJNA857857_P_NODE_14506_length_413_cov_5.100000_g14059_i0	PRJNA857857	14506	413	5.1	21.063	Crocosphaera sp.	2729996	Bacteria	Bacteria	53.9	5.07e-6	NR	MDJ0729159.1	2729996	g14059	i0	33	1.35835351089588	97	63	69	2	295	11	27	123	MDJ0729159.1 hypothetical protein [Crocosphaera sp.]	diamond	561	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera sp.
28634371	28634371	PRJNA857857_P_NODE_5767_length_647_cov_1.512195_g5350_i0	PRJNA857857	5767	647	1.512195	9.78390165	Nostoc sp. CmiVER	1180	Bacteria	Bacteria	150	4.029999999999999e-40	NR	WP_322654162.1	3075384	g5350	i0	37.4	5.7403400309119	211	126	96.4	3	13	636	10	217	WP_322654162.1 methyltransferase [Nostoc sp. CmiVER01]	diamond	3714	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CmiVER01
28918118	28918118	PRJNA857857_P_NODE_8388_length_537_cov_1.308190_g7959_i0	PRJNA857857	8388	537	1.30819	7.0249803	Acaryochloris thomasi	2929456	Bacteria	Bacteria	176	1.82e-50	NR	WP_110985232.1	2929456	g7959	i0	53	0.832402234636871	149	70	83.2	0	90	536	20	168	WP_110985232.1 fatty acid desaturase [Acaryochloris thomasi]	diamond	447	176	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris thomasi
29076324	29076324	PRJNA857857_P_NODE_29448_length_285_cov_1.056604_g28999_i0	PRJNA857857	29448	285	1.056604	3.0113214	Pleurocapsa minor	54308	Bacteria	Bacteria	141	1.48e-38	NR	MBW4438380.1	2839663	g28999	i0	73.4	1.97894736842105	94	25	98.9	0	3	284	4	97	MBW4438380.1 alpha/beta fold hydrolase [Pleurocapsa minor GSE-CHR-MK 17-07R]	diamond	564	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa minor
29494786	29494786	PRJNA857857_P_NODE_1510_length_1157_cov_2.218635_g1259_i0	PRJNA857857	1510	1157	2.218635	25.66960695	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	119	1.14e-25	NR	WP_226576642.1	467598	g1259	i0	37.7	3.24632670700086	215	128	55	4	1139	504	77	288	WP_226576642.1 GMC family oxidoreductase [Microseira wollei]	diamond	3756	120	0.991666666666667	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Microseira	Microseira wollei
29652295	29652295	PRJNA857857_P_NODE_16090_length_392_cov_1.285266_g15643_i0	PRJNA857857	16090	392	1.285266	5.03824272	Microcoleaceae	1892252	Bacteria	Bacteria	63.9	7.61e-10	NR	WP_287528180.1	2607787	g15643	i0	44.8	1.89795918367347	67	36	50.5	1	181	378	31	97	WP_287528180.1 RNA-guided endonuclease InsQ/TnpB family protein [Okeania sp. SIO2C2]	diamond	744	64.3	0.993779160186625	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO2C2
29897238	29897238	PRJNA857857_P_NODE_38251_length_250_cov_0.870056_g37802_i0	PRJNA857857	38251	250	0.870056	2.17514	Tildeniella torsiva	2303520	Bacteria	Bacteria	48.9	2.21e-4	NR	MBW4481095.1	337900	g37802	i0	48.5	0.396	33	17	39.6	0	5	103	201	233	MBW4481095.1 cation diffusion facilitator family transporter [Tildeniella torsiva UHER 1998/13D]	diamond	99	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Tildeniella	Tildeniella torsiva
29991959	29991959	PRJNA857857_P_NODE_45551_length_245_cov_0.895349_g45102_i0	PRJNA857857	45551	245	0.895349	2.19360505	Cyanobacteria bacterium J06560_2	3023136	Bacteria	Bacteria	70.1	6.71e-13	NR	MEL7331761.1	3023136	g45102	i0	42.3	0.955102040816327	78	42	95.5	1	2	235	53	127	MEL7331761.1 hypothetical protein [Cyanobacteria bacterium J06560_2]	diamond	234	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06560_2
30063127	30063127	PRJNA857857_P_NODE_42111_length_247_cov_1.603448_g41662_i0	PRJNA857857	42111	247	1.603448	3.96051656	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	138	1.94e-36	NR	WP_334862294.1	1180	g41662	i0	70.7	4.03238866396761	82	24	99.6	0	1	246	40	121	WP_334862294.1 tyrosinase family protein [Nostoc sp.]	diamond	996	139	0.992805755395683	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
30181408	30181408	PRJNA857857_P_NODE_25652_length_307_cov_0.987179_g25203_i0	PRJNA857857	25652	307	0.987179	3.03063953	Planktothrix tepida	1678309	Bacteria	Bacteria	84	2.56e-16	NR	WP_072722437.1	1678309	g25203	i0	47.8	0.879478827361563	90	47	87.9	0	305	36	312	401	WP_072722437.1 ThiF family adenylyltransferase [Planktothrix tepida]	diamond	270	84	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix tepida
30244802	30244802	PRJNA857857_P_NODE_43772_length_246_cov_0.890173_g43323_i0	PRJNA857857	43772	246	0.890173	2.18982558	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	160	2.85e-45	NR	WP_009631012.1	927677	g43323	i0	93.7	0.963414634146341	79	5	96.3	0	1	237	275	353	WP_009631012.1 adenylosuccinate synthase [Synechocystis sp. PCC 7509]	diamond	237	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
30663535	30663535	PRJNA857857_P_NODE_17193_length_379_cov_1.003268_g16746_i0	PRJNA857857	17193	379	1.003268	3.80238572	Cyanophyceae	3028117	Bacteria	Bacteria	61.6	4.04e-8	NR	WP_073630667.1	1137095	g16746	i0	33.1	6.14248021108179	121	73	91.8	4	353	6	1	118	WP_073630667.1 serine/threonine-protein kinase [Scytonema sp. HK-05]	diamond	2328	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. HK-05
31445553	31445553	PRJNA857857_P_NODE_30356_length_280_cov_1.391304_g29907_i0	PRJNA857857	30356	280	1.391304	3.8956512	Phormidesmis sp. CAN_BIN44	2880265	Bacteria	Bacteria	97.8	3.73e-23	NR	MCY7278519.1	2880265	g29907	i0	53.8	0.996428571428571	93	43	99.6	0	279	1	56	148	MCY7278519.1 oligosaccharide flippase family protein [Phormidesmis sp. CAN_BIN44]	diamond	279	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Phormidesmis	Phormidesmis sp. CAN_BIN44
31666854	31666854	PRJNA857857_P_NODE_17357_length_377_cov_1.013158_g16910_i0	PRJNA857857	17357	377	1.013158	3.81960566	Nostoc sp. DedQUE12a	3075397	Bacteria	Bacteria	139	1.5499999999999998e-37	NR	MDZ8109659.1	3075397	g16910	i0	56.8	6.97877984084881	125	54	99.5	0	376	2	98	222	MDZ8109659.1 PA14 domain-containing protein [Nostoc sp. DedQUE12a]	diamond	2631	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. DedQUE12a

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