metadata: contig_metadata: 20 rows where bioproject = "PRJNA431371" and tax_clade = "Cyanobacteriota/Melainabacteria group"

20 rows where bioproject = "PRJNA431371" 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
8081786	8081786	PRJNA431371_P_NODE_4627_length_550_cov_1.406709_g4554_i0	PRJNA431371	4627	550	1.406709	7.7368995	Stanieria cyanosphaera	102116	Bacteria	Bacteria	289	3.79e-73	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g4554	i0	79.653	29.1436363636364	403	80	73	2	149	550	885	484	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	16029	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
10632238	10632238	PRJNA431371_P_NODE_30169_length_246_cov_1.421965_g30096_i0	PRJNA431371	30169	246	1.421965	3.4980339	Limnothrix sp. BL-A-16	3104318	Bacteria	Bacteria	372	1.5e-98	NTclustered	gi\|2804687704\|gb\|CP166615.1\|	3104318	g30096	i0	93.902	1	246	15	100	0	1	246	2440553	2440308	MAG: Limnothrix sp. BL-A-16 chromosome, complete genome	blastn	246	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix	Limnothrix sp. BL-A-16
10632459	10632459	PRJNA431371_P_NODE_7629_length_445_cov_1.924731_g7556_i0	PRJNA431371	7629	445	1.924731	8.56505295	Cyanobacterium aponinum	379064	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|428682694\|gb\|CP003947.1\|	755178	g7556	i0	92.105	0.413483146067416	38	3	9	0	22	59	1654292	1654329	Cyanobacterium aponinum PCC 10605 chromosome, complete genome	blastn	184	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium aponinum
18279534	18279534	PRJNA431371_P_NODE_13095_length_350_cov_1.101083_g13022_i0	PRJNA431371	13095	350	1.101083	3.8537905	Bacteria	2	Bacteria	Bacteria	92.4	4.980000000000001e-21	NR	PSO83339.1	1919129	g13022	i0	47.5	5.87142857142857	99	50	84.9	1	53	349	4	100	PSO83339.1 MAG: superoxide dismutase family protein [Cyanobacteria bacterium QS_4_48_99]	diamond	2055	92.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium QS_4_48_99
18939404	18939404	PRJNA431371_P_NODE_13115_length_349_cov_2.079710_g13042_i0	PRJNA431371	13115	349	2.07971	7.2581879	Nostocales cyanobacterium ELA608	3064516	Bacteria	Bacteria	114	3.4600000000000003e-29	NR	MEI6371987.1	3064516	g13042	i0	51.4	0.936962750716332	109	51	93.7	1	327	1	11	117	MEI6371987.1 NADH-quinone oxidoreductase subunit C [Nostocales cyanobacterium ELA608]	diamond	327	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium ELA608
26949117	26949117	PRJNA431371_P_NODE_2262_length_715_cov_1.035826_g2189_i0	PRJNA431371	2262	715	1.035826	7.4061559	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	141	8.18e-39	NR	MBX9695543.1	2847862	g2189	i0	87.5	0.335664335664336	80	10	33.6	0	397	636	1	80	MBX9695543.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	240	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27138600	27138600	PRJNA431371_P_NODE_7902_length_439_cov_1.617486_g7829_i0	PRJNA431371	7902	439	1.617486	7.10076354	Scytonema sp. PMC 1069.18	2684455	Bacteria	Bacteria	62.8	2.82e-10	NR	MEC4819658.1	2684455	g7829	i0	65.9	0.553530751708428	41	14	28	0	432	310	1	41	MEC4819658.1 hypothetical protein [Scytonema sp. PMC 1069.18]	diamond	243	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PMC 1069.18
27281977	27281977	PRJNA431371_P_NODE_21243_length_277_cov_1.132353_g21170_i0	PRJNA431371	21243	277	1.132353	3.13661781	Cyanophyceae	3028117	Bacteria	Bacteria	66.6	9.02e-11	NR	WP_338017003.1	2651157	g21170	i0	45.6	5.02527075812274	79	42	84.5	1	277	44	35	113	WP_338017003.1 TVP38/TMEM64 family protein [Myxacorys almedinensis]	diamond	1392	67	0.994029850746269	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Myxacorys	Myxacorys almedinensis
28513423	28513423	PRJNA431371_P_NODE_36107_length_241_cov_0.916667_g36034_i0	PRJNA431371	36107	241	0.916667	2.20916747	Cyanophyceae	3028117	Bacteria	Bacteria	92.8	9.19e-21	NR	WP_038088884.1	1161	g36034	i0	74.6	9.62240663900415	59	15	73.4	0	239	63	208	266	WP_038088884.1 MULTISPECIES: SDR family NAD(P)-dependent oxidoreductase [Nostocales]	diamond	2319	93.6	0.991452991452991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
28591759	28591759	PRJNA431371_P_NODE_18507_length_298_cov_0.871111_g18434_i0	PRJNA431371	18507	298	0.871111	2.59591078	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	115	9.59e-28	NR	MBX9694651.1	2847862	g18434	i0	74.7	0.795302013422819	79	19	78.5	1	298	65	403	481	MBX9694651.1 nicotinate phosphoribosyltransferase [Cyanobacteriota bacterium]	diamond	237	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28623378	28623378	PRJNA431371_P_NODE_35707_length_241_cov_1.809524_g35634_i0	PRJNA431371	35707	241	1.809524	4.36095284	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	52.4	1.47e-5	NR	HEY9756878.1	3088181	g35634	i0	48.3	0.721991701244813	58	28	69.7	1	73	240	180	237	HEY9756878.1 reverse transcriptase domain-containing protein [Oculatellaceae cyanobacterium]	diamond	174	52.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
29128658	29128658	PRJNA431371_P_NODE_16389_length_317_cov_1.262295_g16316_i0	PRJNA431371	16389	317	1.262295	4.00147515	Scytonema sp. PMC 1069.18	2684455	Bacteria	Bacteria	70.5	5.49e-12	NR	MEC4815808.1	2684455	g16316	i0	33.6	6.02839116719243	107	64	96.5	3	2	307	75	179	MEC4815808.1 methyltransferase domain-containing protein [Scytonema sp. PMC 1069.18]	diamond	1911	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PMC 1069.18
29776256	29776256	PRJNA431371_P_NODE_12511_length_357_cov_1.626761_g12438_i0	PRJNA431371	12511	357	1.626761	5.80753677	Bacteria	2	Bacteria	Bacteria	112	3.85e-28	NR	WP_072720583.1	54304	g12438	i0	53.8	12.3781512605042	106	45	89.1	1	349	32	79	180	WP_072720583.1 MULTISPECIES: TVP38/TMEM64 family protein [Planktothrix]	diamond	4419	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix
31071848	31071848	PRJNA431371_P_NODE_12515_length_357_cov_1.626761_g12442_i0	PRJNA431371	12515	357	1.626761	5.80753677	Prochlorococcus	1218	Bacteria	Bacteria	110	1.88e-25	NR	WP_002806085.1	1219	g12442	i0	50	6.45378151260504	102	50	84.9	1	52	354	377	478	WP_002806085.1 PLP-dependent transferase [Prochlorococcus marinus]	diamond	2304	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
31118141	31118141	PRJNA431371_P_NODE_15195_length_328_cov_1.207843_g15122_i0	PRJNA431371	15195	328	1.207843	3.96172504	Halomicronema sp.	3069305	Bacteria	Bacteria	53.5	1.19e-5	NR	HEY9810855.1	3069305	g15122	i0	38	1.29878048780488	71	42	64.9	1	28	240	141	209	HEY9810855.1 DUF3825 domain-containing protein [Halomicronema sp.]	diamond	426	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Halomicronema	Halomicronema sp.
31529662	31529662	PRJNA431371_P_NODE_336_length_1313_cov_2.291129_g289_i0	PRJNA431371	336	1313	2.291129	30.08252377	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	57.8	2.73e-5	NR	MBX9693097.1	2847862	g289	i0	24.3	0.61005331302361	267	173	56.4	8	185	925	1	258	MBX9693097.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	801	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32020538	32020538	PRJNA431371_P_NODE_17878_length_303_cov_1.456522_g17805_i0	PRJNA431371	17878	303	1.456522	4.41326166	Bacillati	1783272	Bacteria	Bacteria	90.1	1.82e-18	NR	MBX9685380.1	2364082	g17805	i0	45.3	4.68316831683168	95	52	94.1	0	297	13	84	178	MBX9685380.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	1419	90.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32035642	32035642	PRJNA431371_P_NODE_5498_length_512_cov_1.605923_g5425_i0	PRJNA431371	5498	512	1.605923	8.22232576	Moorena sp. SIO3I6	2607831	Bacteria	Bacteria	168	1.3699999999999998e-47	NR	WP_293101681.1	2607831	g5425	i0	57.7	3.369140625	142	54	83.2	1	512	87	228	363	WP_293101681.1 alkene reductase [Moorena sp. SIO3I6]	diamond	1725	168	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena sp. SIO3I6
32447170	32447170	PRJNA431371_P_NODE_1159_length_892_cov_1.514042_g1097_i0	PRJNA431371	1159	892	1.514042	13.50525464	Aphanizomenonaceae	1892259	Bacteria	Bacteria	199	2.01e-56	NR	WP_027402938.1	1892259	g1097	i0	36.2	2.902466367713	298	186	99.6	3	890	3	95	390	WP_027402938.1 MULTISPECIES: oligosaccharide flippase family protein [Aphanizomenonaceae]	diamond	2589	199	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae
32542141	32542141	PRJNA431371_P_NODE_9299_length_408_cov_1.149254_g9226_i0	PRJNA431371	9299	408	1.149254	4.68895632	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	66.2	1.29e-9	NR	HEY9739248.1	3081323	g9226	i0	46.6	2.66911764705882	73	39	53.7	0	40	258	316	388	HEY9739248.1 chloride channel protein [Coleofasciculaceae cyanobacterium]	diamond	1089	66.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium

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