metadata: contig_metadata: 25 rows where bioproject = "PRJNA436017" and tax_clade = "Cyanobacteriota/Melainabacteria group"

25 rows where bioproject = "PRJNA436017" 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
1089097	1089097	PRJNA436017_P_NODE_621_length_1126_cov_26.383838_g512_i0	PRJNA436017	621	1126	26.383838	297.08201588	Leptolyngbya	47251	Bacteria	Bacteria	1038	0	NTclustered	gi\|46409901\|gb\|AY584526.1\|	272134	g512	i0	93.352	100.730017761989	707	39	62	6	1	701	623	1327	Leptolyngbya boryana PCC 6306 23S ribosomal RNA gene, partial sequence	blastn	113422	1038	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
1705777	1705777	PRJNA436017_P_NODE_302_length_1459_cov_13.627989_g243_i0	PRJNA436017	302	1459	13.627989	198.83235951	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1122	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g243	i0	80.92	73.4139821795751	1478	232	100	38	1	1459	3682680	3681234	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	107111	1122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
2364453	2364453	PRJNA436017_P_NODE_16662_length_202_cov_1.127273_g16364_i0	PRJNA436017	16662	202	1.127273	2.27709146	Limnospira	2596745	Bacteria	Bacteria	348	2e-91	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g16364	i0	98.01	7.91584158415842	201	3	99	1	1	200	3445515	3445715	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	1599	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
6808747	6808747	PRJNA436017_P_NODE_786_length_1034_cov_20.251755_g652_i0	PRJNA436017	786	1034	20.251755	209.4031467	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	966	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g652	i0	83.699	136.557059961315	1049	145	99	24	2	1034	3681642	3682680	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	141200	966	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8084129	8084129	PRJNA436017_P_NODE_25447_length_161_cov_20.379032_g25149_i0	PRJNA436017	25447	161	20.379032	32.81024152	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	291	2.6e-74	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g25149	i0	100	164.807453416149	157	0	98	0	1	157	1244356	1244512	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	26534	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
13184615	13184615	PRJNA436017_P_NODE_431_length_1296_cov_32.846704_g352_i0	PRJNA436017	431	1296	32.846704	425.69328384	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1199	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g352	i0	83.61	117.571759259259	1324	170	100	42	1	1296	3681376	3682680	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	152373	1199	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14459752	14459752	PRJNA436017_P_NODE_432_length_1296_cov_32.671962_g353_i0	PRJNA436017	432	1296	32.671962	423.42862752	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1194	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g353	i0	83.535	117.571759259259	1324	171	100	42	1	1296	3682680	3681376	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	152373	1194	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
15116789	15116789	PRJNA436017_P_NODE_1152_length_872_cov_41.756886_g980_i0	PRJNA436017	1152	872	41.756886	364.12004592	Oscillatoriales	1150	Bacteria	Bacteria	1520	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g980	i0	99.639	163.577981651376	832	3	95	0	41	872	813274	812443	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	142640	1520	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
15733628	15733628	PRJNA436017_P_NODE_7493_length_324_cov_3.675958_g7196_i0	PRJNA436017	7493	324	3.675958	11.91010392	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	211	4.74e-50	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g7196	i0	78.979	1.62962962962963	333	53	100	13	1	324	125730	126054	Leptolyngbya sp. 7M chromosome	blastn	528	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
17007983	17007983	PRJNA436017_P_NODE_17654_length_195_cov_1.683544_g17356_i0	PRJNA436017	17654	195	1.683544	3.2829108	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	350	5.34e-92	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g17356	i0	98.974	1	195	2	100	0	1	195	3901	3707	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	195	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
17008145	17008145	PRJNA436017_P_NODE_274_length_1493_cov_406.616071_g155_i1	PRJNA436017	274	1493	406.616071	6070.77794003	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	1622	0	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g155	i1	87.535	230.156731413262	1420	156	94	18	1	1410	1246173	1244765	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	343624	1622	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
18282582	18282582	PRJNA436017_P_NODE_555_length_1171_cov_14.016755_g452_i0	PRJNA436017	555	1171	14.016755	164.13620105	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1048	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g452	i0	83.193	65.932536293766	1184	160	99	28	1	1170	3682680	3681522	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	77207	1048	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
20832316	20832316	PRJNA436017_P_NODE_14497_length_219_cov_1.043956_g14199_i0	PRJNA436017	14497	219	1.043956	2.28626364	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	143	1.12e-29	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g14199	i0	78.924	351.826484018265	223	38	99	9	2	219	1479107	1479325	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	77050	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
22107567	22107567	PRJNA436017_P_NODE_5378_length_391_cov_1.567797_g5082_i0	PRJNA436017	5378	391	1.567797	6.13008627	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	94.7	3.9200000000000006e-21	NR	MBX9690859.1	2847862	g5082	i0	40	0.997442455242967	130	70	99.7	2	2	391	86	207	MBX9690859.1 AMP-binding protein [Cyanobacteriota bacterium]	diamond	390	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27739566	27739566	PRJNA436017_P_NODE_13364_length_229_cov_2.578125_g13066_i0	PRJNA436017	13364	229	2.578125	5.90390625	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	97.4	1.6399999999999998e-23	NR	MBX9724270.1	2364082	g13066	i0	98	0.641921397379913	49	1	64.2	0	228	82	122	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	147	97.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27771023	27771023	PRJNA436017_P_NODE_9324_length_285_cov_0.935484_g9026_i0	PRJNA436017	9324	285	0.935484	2.6661294	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	113	5.13e-28	NR	MBX9694561.1	2847862	g9026	i0	70.2	0.884210526315789	84	21	84.2	1	240	1	15	98	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	252	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28275879	28275879	PRJNA436017_P_NODE_22906_length_170_cov_2.849624_g22608_i0	PRJNA436017	22906	170	2.849624	4.8443608	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	42	0.00961	NR	PZM84364.1	2052166	g22608	i0	62.2	0.652941176470588	37	14	65.3	0	128	18	77	113	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	111	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28370632	28370632	PRJNA436017_P_NODE_16346_length_204_cov_1.341317_g16048_i0	PRJNA436017	16346	204	1.341317	2.73628668	Richelia intracellularis	1164990	Bacteria	Bacteria	58.5	5.1e-9	NR	CDN15762.1	1164990	g16048	i0	66.7	1.20588235294118	42	14	61.8	0	198	73	4	45	CDN15762.1 hypothetical protein RintRC_0033 [Richelia intracellularis]	diamond	246	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia intracellularis
29128728	29128728	PRJNA436017_P_NODE_22649_length_171_cov_6.320896_g22351_i0	PRJNA436017	22649	171	6.320896	10.80873216	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	61.2	3.03e-10	NR	PZM84364.1	2052166	g22351	i0	59.6	0.912280701754386	52	21	91.2	0	2	157	64	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	156	61.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29934472	29934472	PRJNA436017_P_NODE_25651_length_161_cov_1.258065_g25353_i0	PRJNA436017	25651	161	1.258065	2.02548465	Cyanophyceae	3028117	Bacteria	Bacteria	80.1	7.96e-16	NR	WP_036536179.1	1501145	g25353	i0	69.8	5.92546583850932	53	16	98.8	0	161	3	351	403	WP_036536179.1 glutamate synthase subunit beta [Neosynechococcus sphagnicola]	diamond	954	80.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Neosynechococcales	Neosynechococcaceae	Neosynechococcus	Neosynechococcus sphagnicola
30012781	30012781	PRJNA436017_P_NODE_19631_length_184_cov_2.591837_g19333_i0	PRJNA436017	19631	184	2.591837	4.76898008	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	45.1	2.19e-4	NR	HEY9844071.1	2364082	g19333	i0	88	0.407608695652174	25	3	40.8	0	79	5	1	25	HEY9844071.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	75	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30044170	30044170	PRJNA436017_P_NODE_29731_length_150_cov_1.035398_g29433_i0	PRJNA436017	29731	150	1.035398	1.553097	Cyanobacteria bacterium P01_H01_bin.152	3023315	Bacteria	Bacteria	72	4.82e-13	NR	MEM1278527.1	3023315	g29433	i0	60.4	2.84	48	19	96	0	149	6	556	603	MEM1278527.1 glycoside hydrolase family 19 protein [Cyanobacteria bacterium P01_H01_bin.152]	diamond	426	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.152
30297523	30297523	PRJNA436017_P_NODE_21952_length_174_cov_2.255474_g21654_i0	PRJNA436017	21952	174	2.255474	3.92452476	Nostocales cyanobacterium ELA608	3064516	Bacteria	Bacteria	45.1	0.00148	NR	MEI6371987.1	3064516	g21654	i0	40.4	0.982758620689655	57	34	98.3	0	172	2	15	71	MEI6371987.1 NADH-quinone oxidoreductase subunit C [Nostocales cyanobacterium ELA608]	diamond	171	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium ELA608
31292912	31292912	PRJNA436017_P_NODE_27695_length_155_cov_1.322034_g27397_i0	PRJNA436017	27695	155	1.322034	2.0491527	Cyanophyceae	3028117	Bacteria	Bacteria	43.9	0.00443	NR	OAB62278.1	322866	g27397	i0	47.5	2.36129032258065	40	21	77.4	0	20	139	634	673	OAB62278.1 hypothetical protein AY599_10795 [Leptolyngbya valderiana BDU 20041]	diamond	366	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya valderiana
32098942	32098942	PRJNA436017_P_NODE_24418_length_165_cov_1.375000_g24120_i0	PRJNA436017	24418	165	1.375	2.26875	Nostoc sp. CHAB 5715	2780400	Bacteria	Bacteria	48.1	1.47e-4	NR	WP_229458700.1	2780400	g24120	i0	87.5	0.436363636363636	24	3	43.6	0	74	3	1	24	WP_229458700.1 hypothetical protein [Nostoc sp. CHAB 5715]	diamond	72	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5715

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