metadata: contig_metadata: 16 rows where bioproject = "PRJNA1227535", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

16 rows where bioproject = "PRJNA1227535", tax_clade = "Cyanobacteriota/Melainabacteria group" 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
1046968	1046968	PRJNA1227535_P_NODE_28081_length_245_cov_1.372093_g27957_i0	PRJNA1227535	28081	245	1.372093	3.36162785	Gloeotrichia	92939	Bacteria	Bacteria	281	2.59e-71	NTclustered	gi\|2707826471\|gb\|CP051186.1\|	2723855	g27957	i0	87.347	2	245	31	100	0	1	245	3603968	3603724	MAG: Gloeotrichia echinulata IR180 chromosome, complete genome	blastn	490	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Gloeotrichiaceae	Gloeotrichia	Gloeotrichia echinulata
2886375	2886375	PRJNA1227535_P_NODE_32803_length_229_cov_3.000000_g32679_i0	PRJNA1227535	32803	229	3	6.87	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	115	2.57e-21	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g32679	i0	89.13	0.40174672489083	92	10	40	0	26	117	2174046	2173955	Leptolyngbya sp. 7M chromosome	blastn	92	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
6713164	6713164	PRJNA1227535_P_NODE_29906_length_243_cov_0.917647_g29782_i0	PRJNA1227535	29906	243	0.917647	2.22988221	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	344	3.23e-90	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g29782	i0	92.5	1.86831275720165	240	18	99	0	4	243	987329	987090	Nodosilinea sp. E11 chromosome	blastn	454	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
27325671	27325671	PRJNA1227535_P_NODE_28263_length_245_cov_0.906977_g28139_i0	PRJNA1227535	28263	245	0.906977	2.22209365	Trichocoleus sp. FACHB-591	2692872	Bacteria	Bacteria	155	6.68e-42	NR	WP_190550351.1	2692872	g28139	i0	87.7	1.98367346938776	81	10	99.2	0	243	1	1208	1288	WP_190550351.1 N-6 DNA methylase [Trichocoleus sp. FACHB-591]	diamond	486	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp. FACHB-591
28557202	28557202	PRJNA1227535_P_NODE_16927_length_268_cov_2.907692_g16804_i0	PRJNA1227535	16927	268	2.907692	7.79261456	Aliterella atlantica	1827278	Bacteria	Bacteria	151	1.0899999999999998e-41	NR	WP_200892242.1	1827278	g16804	i0	84.3	0.996268656716418	89	14	99.6	0	267	1	286	374	WP_200892242.1 LCP family protein [Aliterella atlantica]	diamond	267	151	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
28557205	28557205	PRJNA1227535_P_NODE_18947_length_262_cov_1.650794_g18823_i0	PRJNA1227535	18947	262	1.650794	4.32508028	Scytonema sp. PRP1	3120513	Bacteria	Bacteria	124	1.34e-30	NR	WP_332993737.1	3120513	g18823	i0	70.2	1.75190839694656	84	24	95	1	14	262	195	278	WP_332993737.1 type I secretion system permease/ATPase [Scytonema sp. PRP1]	diamond	459	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PRP1
28588827	28588827	PRJNA1227535_P_NODE_26427_length_247_cov_1.339080_g26303_i0	PRJNA1227535	26427	247	1.33908	3.3075276	Aliterella atlantica	1827278	Bacteria	Bacteria	153	9.81e-45	NR	WP_072044972.1	1827278	g26303	i0	82.7	0.983805668016194	81	14	98.4	0	247	5	18	98	WP_072044972.1 zinc-finger-containing protein [Aliterella atlantica]	diamond	243	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
28922976	28922976	PRJNA1227535_P_NODE_25028_length_249_cov_0.886364_g24904_i0	PRJNA1227535	25028	249	0.886364	2.20704636	Cyanophyceae	3028117	Bacteria	Bacteria	160	5.15e-46	NR	WP_045055921.1	1827278	g24904	i0	100	3.90361445783133	81	0	97.6	0	244	2	151	231	WP_045055921.1 S1C family serine protease [Aliterella atlantica]	diamond	972	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
29756748	29756748	PRJNA1227535_P_NODE_18331_length_264_cov_1.612565_g18207_i0	PRJNA1227535	18331	264	1.612565	4.2571716	Nostoc sp. XA013	2780408	Bacteria	Bacteria	76.3	1.45e-15	NR	MCC5654631.1	2780408	g18207	i0	53.2	0.704545454545455	62	29	70.5	0	6	191	46	107	MCC5654631.1 hypothetical protein [Nostoc sp. XA013]	diamond	186	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. XA013
29965188	29965188	PRJNA1227535_P_NODE_26591_length_247_cov_0.896552_g26467_i0	PRJNA1227535	26591	247	0.896552	2.21448344	Cyanophyceae	3028117	Bacteria	Bacteria	163	6.7599999999999985e-47	NR	WP_009631263.1	927677	g26467	i0	95.1	1.97975708502024	81	4	98.4	0	5	247	193	273	WP_009631263.1 tetratricopeptide repeat protein [Synechocystis sp. PCC 7509]	diamond	489	164	0.99390243902439	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
30565094	30565094	PRJNA1227535_P_NODE_9673_length_294_cov_1.855204_g9550_i0	PRJNA1227535	9673	294	1.855204	5.45429976	Cyanophyceae	3028117	Bacteria	Bacteria	100	2.54e-22	NR	WP_414586161.1	1680591	g9550	i0	59.6	6.6734693877551	94	35	92.9	2	293	21	266	359	WP_414586161.1 AAA-like domain-containing protein [Scytonema sp. PCC 10023]	diamond	1962	101	0.99009900990099	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PCC 10023
30862606	30862606	PRJNA1227535_P_NODE_30614_length_242_cov_0.923077_g30490_i0	PRJNA1227535	30614	242	0.923077	2.23384634	Aliterella atlantica	1827278	Bacteria	Bacteria	129	1.68e-35	NR	WP_045056720.1	1827278	g30490	i0	78.8	0.991735537190083	80	17	99.2	0	1	240	79	158	WP_045056720.1 ACP phosphodiesterase [Aliterella atlantica]	diamond	240	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31020706	31020706	PRJNA1227535_P_NODE_29735_length_243_cov_0.917647_g29611_i0	PRJNA1227535	29735	243	0.917647	2.22988221	Aliterella atlantica	1827278	Bacteria	Bacteria	147	3.96e-39	NR	WP_045056169.1	1827278	g29611	i0	97.5	0.987654320987654	80	2	98.8	0	3	242	131	210	WP_045056169.1 cation:proton antiporter [Aliterella atlantica]	diamond	240	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31209690	31209690	PRJNA1227535_P_NODE_11775_length_286_cov_1.892019_g11652_i0	PRJNA1227535	11775	286	1.892019	5.41117434	Pantanalinema sp. GBBB05	2604139	Bacteria	Bacteria	47.4	0.00154	NR	MBL1177968.1	2604139	g11652	i0	44.2	1.86713286713287	86	37	89.2	4	271	17	1374	1449	MBL1177968.1 filamentous hemagglutinin N-terminal domain-containing protein [Pantanalinema sp. GBBB05]	diamond	534	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Pantanalinema	Pantanalinema sp. GBBB05
31387264	31387264	PRJNA1227535_P_NODE_22776_length_252_cov_0.871508_g22652_i0	PRJNA1227535	22776	252	0.871508	2.19620016	Nostoc	1177	Bacteria	Bacteria	58.9	4.88e-9	NR	MEH2076801.1	1180	g22652	i0	83.9	2.21428571428571	31	5	36.9	0	93	1	1	31	MEH2076801.1 RNA-guided endonuclease TnpB family protein [Nostoc sp.]	diamond	558	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
32696347	32696347	PRJNA1227535_P_NODE_17980_length_265_cov_1.625000_g17857_i0	PRJNA1227535	17980	265	1.625	4.30625	Leptolyngbya sp. FACHB-541	2692810	Bacteria	Bacteria	137	8.339999999999999e-38	NR	WP_190796502.1	2692810	g17857	i0	79.5	2.96603773584906	88	18	99.6	0	2	265	157	244	WP_190796502.1 SDR family oxidoreductase [Leptolyngbya sp. FACHB-541]	diamond	786	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-541

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