metadata: contig_metadata: 19 rows where bioproject = "PRJNA1159911" and tax_clade = "Cyanobacteriota/Melainabacteria group"

19 rows where bioproject = "PRJNA1159911" 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
308893	308893	PRJNA1159911_P_NODE_97661_length_243_cov_1.376471_g97119_i0	PRJNA1159911	97661	243	1.376471	3.34482453	unclassified Synechococcus	2626047	Bacteria	Bacteria	91.7	2.07e-21	NR	WP_011429941.1	2626047	g97119	i0	71.2	5.17283950617284	52	15	64.2	0	5	160	98	149	WP_011429941.1 MULTISPECIES: nucleoside-diphosphate kinase [unclassified Synechococcus]	diamond	1257	91.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus
1037867	1037867	PRJNA1159911_P_NODE_104961_length_199_cov_7.325397_g104419_i0	PRJNA1159911	104961	199	7.325397	14.57754003	root	1	Root_unresolved	Root_unresolved	364	1.9499999999999995e-96	NTclustered	gi\|588284496\|gb\|KF951520.1\|	1211	g104419	i0	100	102.562814070352	197	0	99	0	1	197	106	302	Uncultured cyanobacterium clone PS41 16S ribosomal RNA gene, partial sequence	blastn	20410	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1583349	1583349	PRJNA1159911_P_NODE_88562_length_250_cov_0.870056_g88020_i0	PRJNA1159911	88562	250	0.870056	2.17514	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	167	9.58e-49	NR	HEY9757298.1	3088181	g88020	i0	100	0.996	83	0	99.6	0	2	250	134	216	HEY9757298.1 glycosyltransferase family 1 protein [Oculatellaceae cyanobacterium]	diamond	249	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
26819002	26819002	PRJNA1159911_P_NODE_84161_length_255_cov_1.989011_g83619_i0	PRJNA1159911	84161	255	1.989011	5.07197805	Cyanobacteria bacterium REEB67	2800110	Bacteria	Bacteria	52	1.31e-5	NR	MBU6451668.1	2800110	g83619	i0	43.9	0.670588235294118	57	28	62.4	1	96	254	5	61	MBU6451668.1 hypothetical protein [Cyanobacteria bacterium REEB67]	diamond	171	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium REEB67
27482817	27482817	PRJNA1159911_P_NODE_98563_length_243_cov_0.905882_g98021_i0	PRJNA1159911	98563	243	0.905882	2.20129326	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	150	1.1399999999999996e-43	NR	HEY9760168.1	3088181	g98021	i0	100	0.888888888888889	72	0	88.9	0	26	241	1	72	HEY9760168.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	216	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
27956442	27956442	PRJNA1159911_P_NODE_87005_length_251_cov_0.865169_g86463_i0	PRJNA1159911	87005	251	0.865169	2.17157419	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	156	3.71e-46	NR	HEY9759201.1	3088181	g86463	i0	100	0.860557768924303	72	0	86.1	0	250	35	132	203	HEY9759201.1 AbrB/MazE/SpoVT family DNA-binding domain-containing protein [Oculatellaceae cyanobacterium]	diamond	216	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28512433	28512433	PRJNA1159911_P_NODE_100427_length_241_cov_1.797619_g99885_i0	PRJNA1159911	100427	241	1.797619	4.33226179	Bacteria	2	Bacteria	Bacteria	44.3	0.01	NR	WP_012163019.1	155978	g99885	i0	46.3	1.04564315352697	41	22	51	0	237	115	303	343	WP_012163019.1 ankyrin repeat domain-containing protein [Acaryochloris marina]	diamond	252	44.7	0.991051454138702	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina
28935269	28935269	PRJNA1159911_P_NODE_91068_length_248_cov_0.880000_g90526_i0	PRJNA1159911	91068	248	0.88	2.1824	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	151	1.31e-40	NR	HIA54823.1	2052166	g90526	i0	85.4	0.991935483870968	82	12	99.2	0	246	1	92	173	HIA54823.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Melainabacteria bacterium]	diamond	246	151	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29629451	29629451	PRJNA1159911_P_NODE_95110_length_245_cov_0.895349_g94568_i0	PRJNA1159911	95110	245	0.895349	2.19360505	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	114	8.79e-28	NR	MBY0548834.1	2364082	g94568	i0	91.4	0.991836734693878	81	7	99.2	0	245	3	335	415	MBY0548834.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	243	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29819067	29819067	PRJNA1159911_P_NODE_91471_length_248_cov_0.880000_g90929_i0	PRJNA1159911	91471	248	0.88	2.1824	Cyanobacteria bacterium RI_101	2775578	Bacteria	Bacteria	57	3.55e-7	NR	MBJ7901168.1	2775578	g90929	i0	50	0.75	62	29	72.6	1	3	182	315	376	MBJ7901168.1 ankyrin repeat domain-containing protein [Cyanobacteria bacterium RI_101]	diamond	186	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium RI_101
30008995	30008995	PRJNA1159911_P_NODE_83851_length_256_cov_1.360656_g83309_i0	PRJNA1159911	83851	256	1.360656	3.48327936	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	171	9.65e-50	NR	PZM83381.1	2052166	g83309	i0	96.5	0.99609375	85	3	99.6	0	2	256	233	317	PZM83381.1 MAG: glycosidase [Candidatus Melainabacteria bacterium]	diamond	255	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30071865	30071865	PRJNA1159911_P_NODE_72732_length_277_cov_2.161765_g72190_i0	PRJNA1159911	72732	277	2.161765	5.98808905	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	153	8.37e-46	NR	MBX9722668.1	2364082	g72190	i0	81.1	0.974729241877256	90	17	97.5	0	1	270	39	128	MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	270	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30071870	30071870	PRJNA1159911_P_NODE_91012_length_248_cov_0.880000_g90470_i0	PRJNA1159911	91012	248	0.88	2.1824	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	73.6	3.37e-13	NR	HEY9754784.1	3088181	g90470	i0	97.3	0.44758064516129	37	1	44.8	0	113	3	1	37	HEY9754784.1 LysR substrate-binding domain-containing protein [Oculatellaceae cyanobacterium]	diamond	111	73.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30198156	30198156	PRJNA1159911_P_NODE_99492_length_242_cov_0.911243_g98950_i0	PRJNA1159911	99492	242	0.911243	2.20520806	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	43.9	0.0146	NR	BAU13752.1	1752064	g98950	i0	65.7	1.63636363636364	35	12	43.4	0	68	172	56	90	BAU13752.1 hypothetical protein LEP3755_42930 [Leptolyngbya sp. NIES-3755]	diamond	396	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
30514316	30514316	PRJNA1159911_P_NODE_89653_length_249_cov_0.875000_g89111_i0	PRJNA1159911	89653	249	0.875	2.17875	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	155	7.1e-44	NR	PZM84537.1	2052166	g89111	i0	100	1	83	0	100	0	249	1	117	199	PZM84537.1 MAG: hypothetical protein DKT66_07850 [Candidatus Melainabacteria bacterium]	diamond	249	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30881127	30881127	PRJNA1159911_P_NODE_70734_length_282_cov_1.186603_g70192_i0	PRJNA1159911	70734	282	1.186603	3.34622046	Bacillati	1783272	Bacteria	Bacteria	108	3.62e-27	NR	MDR3615357.1	2364082	g70192	i0	56.7	5.82978723404255	90	39	95.7	0	13	282	30	119	MDR3615357.1 tyrosine-type recombinase/integrase [Candidatus Obscuribacterales bacterium]	diamond	1644	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31145774	31145774	PRJNA1159911_P_NODE_8695_length_1138_cov_5.163380_g8317_i0	PRJNA1159911	8695	1138	5.16338	58.7592644	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	468	2.45e-162	NR	MBX9694561.1	2847862	g8317	i0	74.4	2.54657293497364	308	74	79.9	2	46	954	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2898	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32538308	32538308	PRJNA1159911_P_NODE_75319_length_272_cov_1.321608_g74777_i0	PRJNA1159911	75319	272	1.321608	3.59477376	Moorena sp. SIO3C2	2607842	Bacteria	Bacteria	55.5	1.6e-6	NR	NEP52929.1	2607842	g74777	i0	54.5	2.18382352941176	44	20	48.5	0	174	43	1	44	NEP52929.1 tetratricopeptide repeat-containing protein [Moorena sp. SIO3C2]	diamond	594	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena sp. SIO3C2
32632464	32632464	PRJNA1159911_P_NODE_95680_length_245_cov_0.895349_g95138_i0	PRJNA1159911	95680	245	0.895349	2.19360505	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	157	2.849999999999999e-43	NR	MBX9950447.1	2364082	g95138	i0	96.3	0.991836734693878	81	3	99.2	0	245	3	290	370	MBX9950447.1 DUF4388 domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	243	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium

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