metadata: contig_metadata: 26 rows where bioproject = "PRJNA453567" and tax_clade = "Cyanobacteriota/Melainabacteria group"

26 rows where bioproject = "PRJNA453567" 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
6819494	6819494	PRJNA453567_P_NODE_20586_length_195_cov_1.132911_g20349_i0	PRJNA453567	20586	195	1.132911	2.20917645	Cyanobium sp. M30B3	2831057	Bacteria	Bacteria	62.1	2.8e-5	NTclustered	gi\|2041287931\|gb\|CP073761.1\|	2831057	g20349	i0	100	0.887179487179487	33	0	17	0	158	190	2400205	2400173	MAG: Cyanobium sp. M30B3 chromosome, complete genome	blastn	173	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. M30B3
6819583	6819583	PRJNA453567_P_NODE_33786_length_151_cov_1.026316_g33549_i0	PRJNA453567	33786	151	1.026316	1.54973716	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	63.9	3.56e-10	NR	WP_190403019.1	71190	g33549	i0	66.7	8.36423841059603	42	14	83.4	0	26	151	856	897	WP_190403019.1 PAS domain-containing protein [Pseudanabaena mucicola]	diamond	1263	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena mucicola
10021636	10021636	PRJNA453567_P_NODE_34088_length_150_cov_1.380531_g33851_i0	PRJNA453567	34088	150	1.380531	2.0707965	Bacillati	1783272	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|2041287931\|gb\|CP073761.1\|	2831057	g33851	i0	100	0.373333333333333	28	0	19	0	52	79	2400201	2400174	MAG: Cyanobium sp. M30B3 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. M30B3
10645706	10645706	PRJNA453567_P_NODE_25669_length_173_cov_1.433824_g25432_i0	PRJNA453567	25669	173	1.433824	2.48051552	Cyanobium sp. M30B3	2831057	Bacteria	Bacteria	62.1	2.41e-5	NTclustered	gi\|2041287931\|gb\|CP073761.1\|	2831057	g25432	i0	97.297	0.213872832369942	37	0	21	1	69	105	217668	217633	MAG: Cyanobium sp. M30B3 chromosome, complete genome	blastn	37	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. M30B3
13195440	13195440	PRJNA453567_P_NODE_24351_length_178_cov_1.106383_g24114_i0	PRJNA453567	24351	178	1.106383	1.96936174	Synechococcus sp. ROS8604	1442557	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1895785424\|gb\|CP047946.1\|	1442557	g24114	i0	100	0.162921348314607	29	0	16	0	74	102	1574594	1574622	Synechococcus sp. ROS8604 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. ROS8604
18944871	18944871	PRJNA453567_P_NODE_16495_length_221_cov_1.271739_g16258_i0	PRJNA453567	16495	221	1.271739	2.81054319	Bacteria	2	Bacteria	Bacteria	237	5.04e-58	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g16258	i0	86.512	87.8733031674208	215	29	97	0	7	221	1487731	1487517	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	19420	237	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
26839436	26839436	PRJNA453567_P_NODE_7201_length_366_cov_2.851064_g6964_i0	PRJNA453567	7201	366	2.851064	10.43489424	Bacteria	2	Bacteria	Bacteria	98.2	4.7500000000000005e-21	NR	NJR60769.1	2720403	g6964	i0	46.5	2.48360655737705	101	50	82.8	1	365	63	362	458	NJR60769.1 hypothetical protein [Cyanobacteria bacterium CRU_2_1]	diamond	909	98.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium CRU_2_1
26886476	26886476	PRJNA453567_P_NODE_3181_length_613_cov_2.479167_g2968_i0	PRJNA453567	3181	613	2.479167	15.19729371	Cyanobacteria bacterium J06582_2	3023143	Bacteria	Bacteria	70.9	1.98e-10	NR	MEL7079368.1	3023143	g2968	i0	31.1	2.3931484502447	151	99	71.9	2	503	63	295	444	MEL7079368.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06582_2]	diamond	1467	70.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06582_2
27044547	27044547	PRJNA453567_P_NODE_382_length_1684_cov_4.515483_g348_i0	PRJNA453567	382	1684	4.515483	76.04073372	Aphanizomenon flos-aquae WA1	1176	Bacteria	Bacteria	53.9	0.00103	NR	OBQ36479.1	1710896	g348	i0	34.9	0.147862232779097	83	54	14.8	0	789	1037	191	273	OBQ36479.1 MAG: hypothetical protein AN484_25665 [Aphanizomenon flos-aquae WA102]	diamond	249	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
27138932	27138932	PRJNA453567_P_NODE_19042_length_203_cov_1.740964_g18805_i0	PRJNA453567	19042	203	1.740964	3.53415692	Cyanobacteria bacterium P01_G01_bin.19	3023302	Bacteria	Bacteria	45.1	0.00339	NR	MEM8831642.1	3023302	g18805	i0	50	0.70935960591133	48	23	70.9	1	44	187	528	574	MEM8831642.1 hypothetical protein [Cyanobacteria bacterium P01_G01_bin.19]	diamond	144	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_G01_bin.19
27819043	27819043	PRJNA453567_P_NODE_12324_length_263_cov_2.048673_g12087_i0	PRJNA453567	12324	263	2.048673	5.38800999	Bacteria	2	Bacteria	Bacteria	50.4	9.15e-5	NR	MEL6490829.1	3023163	g12087	i0	57.5	1.34600760456274	40	17	45.6	0	2	121	660	699	MEL6490829.1 hypothetical protein [Cyanobacteria bacterium J06621_3]	diamond	354	50.8	0.992125984251969	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06621_3
27865659	27865659	PRJNA453567_P_NODE_17525_length_213_cov_1.812500_g17288_i0	PRJNA453567	17525	213	1.8125	3.860625	Dulcicalothrix desertica	32056	Bacteria	Bacteria	52.8	7.34e-6	NR	WP_127081624.1	32056	g17288	i0	43.1	4.38028169014085	65	37	91.5	0	18	212	626	690	WP_127081624.1 NB-ARC domain-containing protein [Dulcicalothrix desertica]	diamond	933	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
27976697	27976697	PRJNA453567_P_NODE_22585_length_185_cov_1.317568_g22348_i0	PRJNA453567	22585	185	1.317568	2.4375008	Bacteria	2	Bacteria	Bacteria	51.2	1.31e-5	NR	WP_208344833.1	1550245	g22348	i0	55.3	5.54594594594595	47	18	76.2	1	162	22	163	206	WP_208344833.1 CAP domain-containing protein [Aetokthonos hydrillicola]	diamond	1026	51.6	0.992248062015504	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Aetokthonos	Aetokthonos hydrillicola
27992230	27992230	PRJNA453567_P_NODE_29945_length_160_cov_1.268293_g29708_i0	PRJNA453567	29945	160	1.268293	2.0292688	Okeania sp. SIO2B3	2607784	Bacteria	Bacteria	52	2.1e-6	NR	WP_293065473.1	2607784	g29708	i0	37.7	0.99375	53	25	99.4	1	2	160	76	120	WP_293065473.1 hypothetical protein [Okeania sp. SIO2B3]	diamond	159	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO2B3
28465866	28465866	PRJNA453567_P_NODE_386_length_1675_cov_3.612332_g352_i0	PRJNA453567	386	1675	3.612332	60.506561	Aphanizomenon flos-aquae WA1	1176	Bacteria	Bacteria	85.1	5.43e-14	NR	OBQ36479.1	1710896	g352	i0	25.7	0.494328358208955	276	176	48	8	486	1289	21	275	OBQ36479.1 MAG: hypothetical protein AN484_25665 [Aphanizomenon flos-aquae WA102]	diamond	828	85.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
28655233	28655233	PRJNA453567_P_NODE_23307_length_182_cov_1.344828_g23070_i0	PRJNA453567	23307	182	1.344828	2.44758696	[Leptolyngbya] sp. PCC 7376	111781	Bacteria	Bacteria	51.2	1.65e-5	NR	WP_083891087.1	111781	g23070	i0	47.9	0.791208791208791	48	25	79.1	0	13	156	5	52	WP_083891087.1 actin [[Leptolyngbya] sp. PCC 7376]	diamond	144	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Leptolyngbya] sp. PCC 7376
28829121	28829121	PRJNA453567_P_NODE_5388_length_439_cov_1.649254_g5153_i0	PRJNA453567	5388	439	1.649254	7.24022506	Bacteria	2	Bacteria	Bacteria	115	9.5e-27	NR	NJR60769.1	2720403	g5153	i0	44.9	1.88610478359909	138	71	93.6	3	413	3	133	266	NJR60769.1 hypothetical protein [Cyanobacteria bacterium CRU_2_1]	diamond	828	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium CRU_2_1
29097320	29097320	PRJNA453567_P_NODE_988_length_1175_cov_2.337434_g905_i0	PRJNA453567	988	1175	2.337434	27.4648495	Aphanizomenon flos-aquae WA1	1176	Bacteria	Bacteria	60.8	3.15e-6	NR	OBQ36479.1	1710896	g905	i0	23	0.68936170212766	270	151	66.1	5	843	67	41	264	OBQ36479.1 MAG: hypothetical protein AN484_25665 [Aphanizomenon flos-aquae WA102]	diamond	810	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
29760095	29760095	PRJNA453567_P_NODE_9531_length_308_cov_1.719557_g9294_i0	PRJNA453567	9531	308	1.719557	5.29623556	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	72	1.09e-12	NR	PKL79759.1	2013813	g9294	i0	44	3.53571428571429	91	36	88.6	1	10	282	58	133	PKL79759.1 MAG: glycoside hydrolase, partial [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	1089	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
30724193	30724193	PRJNA453567_P_NODE_18974_length_204_cov_1.161677_g18737_i0	PRJNA453567	18974	204	1.161677	2.36982108	Nostoc	1177	Bacteria	Bacteria	62.8	1.86e-9	NR	WP_251956198.1	1178	g18737	i0	44.1	2.60294117647059	59	33	86.8	0	15	191	134	192	WP_251956198.1 sensor histidine kinase [Nostoc commune]	diamond	531	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
30802798	30802798	PRJNA453567_P_NODE_23534_length_181_cov_1.527778_g23297_i0	PRJNA453567	23534	181	1.527778	2.76527818	Thermoleptolyngbya oregonensis NK1-22	2547457	Bacteria	Bacteria	51.6	1.23e-5	NR	WOB42701.1	2547457	g23297	i0	53.2	1.55801104972376	47	19	72.9	1	174	43	108	154	WOB42701.1 GAF domain-containing protein [Thermoleptolyngbya oregonensis NK1-22]	diamond	282	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
31371885	31371885	PRJNA453567_P_NODE_14756_length_236_cov_1.010050_g14519_i0	PRJNA453567	14756	236	1.01005	2.383718	Spirulina major	270636	Bacteria	Bacteria	50.1	8.97e-5	NR	WP_072621944.1	270636	g14519	i0	60	2.64406779661017	40	15	50.8	1	109	228	154	192	WP_072621944.1 GAF domain-containing protein [Spirulina major]	diamond	624	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina major
31719644	31719644	PRJNA453567_P_NODE_16977_length_217_cov_1.605556_g16740_i0	PRJNA453567	16977	217	1.605556	3.48405652	Synechococcaceae cyanobacterium	2588875	Bacteria	Bacteria	42	0.0488	NR	MEB3172021.1	2588875	g16740	i0	52.7	0.76036866359447	55	21	71.9	3	43	198	165	217	MEB3172021.1 hydrogenase expression/formation protein HypE [Synechococcaceae cyanobacterium]	diamond	165	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae cyanobacterium
31940898	31940898	PRJNA453567_P_NODE_2917_length_645_cov_2.092105_g2716_i0	PRJNA453567	2917	645	2.092105	13.49407725	Cyanobacteria bacterium P01_F01_bin.4	3023297	Bacteria	Bacteria	50.1	0.00279	NR	MEM9163855.1	3023297	g2716	i0	67.6	0.846511627906977	37	12	17.2	0	2	112	336	372	MEM9163855.1 response regulator [Cyanobacteria bacterium P01_F01_bin.4]	diamond	546	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_F01_bin.4
32020631	32020631	PRJNA453567_P_NODE_8358_length_335_cov_1.651007_g8121_i0	PRJNA453567	8358	335	1.651007	5.53087345	Cyanophyceae	3028117	Bacteria	Bacteria	52.4	4.46e-5	NR	WP_127082874.1	32056	g8121	i0	32.4	3.78805970149254	105	49	94	3	332	18	313	395	WP_127082874.1 WD40/YVTN/BNR-like repeat-containing protein [Dulcicalothrix desertica]	diamond	1269	52.8	0.992424242424242	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
32731385	32731385	PRJNA453567_P_NODE_4880_length_469_cov_2.347222_g4645_i0	PRJNA453567	4880	469	2.347222	11.00847118	Aphanocapsa feldmannii 277cV	2507553	Bacteria	Bacteria	43.5	0.0449	NR	TGG91043.1	2507553	g4645	i0	33.3	0.383795309168444	60	32	34.5	2	39	200	18	75	TGG91043.1 MAG: NIPSNAP family protein [Aphanocapsa feldmannii 277cV]	diamond	180	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Aphanocapsa	Aphanocapsa feldmannii

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