metadata: contig_metadata: 17 rows where bioproject = "PRJNA414225" and tax_clade = "Cyanobacteriota/Melainabacteria group"

17 rows where bioproject = "PRJNA414225" 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
6796660	6796660	PRJNA414225_P_NODE_33626_length_176_cov_1.606299_g33539_i0	PRJNA414225	33626	176	1.606299	2.82708624	Thermosynechococcus sp.	2814275	Bacteria	Bacteria	209	8.33e-50	NTclustered	gi\|2314731918\|dbj\|AP024678.1\|	2814275	g33539	i0	88.068	2.01704545454545	176	21	100	0	1	176	754846	755021	MAG: Thermosynechococcus sp. KatS3mg067 DNA, complete genome	blastn	355	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus sp.
9347001	9347001	PRJNA414225_P_NODE_12108_length_202_cov_0.993464_g12021_i0	PRJNA414225	12108	202	0.993464	2.00679728	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	344	2.59e-90	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g12021	i0	97.99	135.232673267327	199	3	98	1	1	198	2725	2923	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27317	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15721599	15721599	PRJNA414225_P_NODE_52293_length_167_cov_0.864407_g52206_i0	PRJNA414225	52293	167	0.864407	1.44355969	Nostoc punctiforme	272131	Bacteria	Bacteria	63.9	6.47e-6	NTclustered	gi\|186463002\|gb\|CP001037.1\|	63737	g52206	i0	100	4.9940119760479	34	0	20	0	53	86	4752225	4752192	Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome	blastn	834	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
23371085	23371085	PRJNA414225_P_NODE_68659_length_164_cov_1.773913_g68572_i0	PRJNA414225	68659	164	1.773913	2.90921732	cyanobacterium TDX16	1503470	Bacteria	Bacteria	93.2	4.84e-22	NR	OWY61347.1	1503470	g68572	i0	92.5	2.94512195121951	53	4	97	0	163	5	93	145	OWY61347.1 IS256 family transposase, partial [cyanobacterium TDX16]	diamond	483	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16
26775868	26775868	PRJNA414225_P_NODE_17721_length_189_cov_1.457143_g17634_i0	PRJNA414225	17721	189	1.457143	2.75400027	Bacteria	2	Bacteria	Bacteria	110	4.3200000000000005e-27	NR	OGI20725.1	1801607	g17634	i0	80.6	1.96825396825397	62	12	98.4	0	186	1	93	154	OGI20725.1 MAG: uroporphyrinogen decarboxylase [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	372	111	0.990990990990991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
27707838	27707838	PRJNA414225_P_NODE_75884_length_163_cov_1.868421_g75797_i0	PRJNA414225	75884	163	1.868421	3.04552623	Chamaesiphon polymorphus	2107691	Bacteria	Bacteria	80.9	3.23e-16	NR	WP_106300000.1	2107691	g75797	i0	61.8	1.96932515337423	55	19	97.5	1	2	160	261	315	WP_106300000.1 glycoside hydrolase family 99-like domain-containing protein [Chamaesiphon polymorphus]	diamond	321	80.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon polymorphus
27865089	27865089	PRJNA414225_P_NODE_71905_length_164_cov_0.886957_g71818_i0	PRJNA414225	71905	164	0.886957	1.45460948	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	52	6.98e-6	NR	MDY6937925.1	2847862	g71818	i0	56.1	2.57926829268293	41	18	75	0	161	39	2002	2042	MDY6937925.1 SDR family NAD(P)-dependent oxidoreductase [Cyanobacteriota bacterium]	diamond	423	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28117727	28117727	PRJNA414225_P_NODE_71605_length_164_cov_0.886957_g71518_i0	PRJNA414225	71605	164	0.886957	1.45460948	Planktothrix sp.	3088171	Bacteria	Bacteria	56.6	1.62e-7	NR	HEY9776519.1	3088171	g71518	i0	65	0.731707317073171	40	14	73.2	0	164	45	500	539	HEY9776519.1 non-homologous end-joining DNA ligase [Planktothrix sp.]	diamond	120	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp.
28134633	28134633	PRJNA414225_P_NODE_83845_length_162_cov_1.575221_g83758_i0	PRJNA414225	83845	162	1.575221	2.55185802	Bacillati	1783272	Bacteria	Bacteria	84.3	2.72e-17	NR	MBA4073762.1	2067979	g83758	i0	86.5	3.7037037037037	52	7	96.3	0	162	7	30	81	MBA4073762.1 ATPase [Cyanobacteria bacterium PR.023]	diamond	600	84.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
28149518	28149518	PRJNA414225_P_NODE_77685_length_163_cov_0.894737_g77598_i0	PRJNA414225	77685	163	0.894737	1.45842131	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	73.9	3.76e-14	NR	MDZ4835737.1	2052166	g77598	i0	66.7	0.993865030674847	54	18	99.4	0	163	2	121	174	MDZ4835737.1 GDSL-type esterase/lipase family protein [Candidatus Melainabacteria bacterium]	diamond	162	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28228937	28228937	PRJNA414225_P_NODE_80606_length_163_cov_0.894737_g80519_i0	PRJNA414225	80606	163	0.894737	1.45842131	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	62	2.04e-9	NR	WP_016952818.1	163908	g80519	i0	62.3	8.77914110429448	53	11	97.5	2	162	4	809	852	WP_016952818.1 non-ribosomal peptide synthetase [Anabaena sp. PCC 7108]	diamond	1431	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. PCC 7108
28780737	28780737	PRJNA414225_P_NODE_89147_length_162_cov_0.902655_g89060_i0	PRJNA414225	89147	162	0.902655	1.4623011	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	80.5	1.64e-16	NR	HEY9793324.1	2364082	g89060	i0	64.2	0.981481481481482	53	19	98.1	0	3	161	51	103	HEY9793324.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	159	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29664598	29664598	PRJNA414225_P_NODE_19950_length_187_cov_1.478261_g19863_i0	PRJNA414225	19950	187	1.478261	2.76434807	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	92.4	3.71e-21	NR	MBI3591376.1	2052166	g19863	i0	71	0.994652406417112	62	17	99.5	1	187	2	167	227	MBI3591376.1 nucleotidyltransferase family protein [Candidatus Melainabacteria bacterium]	diamond	186	92.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29917741	29917741	PRJNA414225_P_NODE_58551_length_166_cov_0.871795_g58464_i0	PRJNA414225	58551	166	0.871795	1.4471797	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	73.6	1.72e-13	NR	MBX9951133.1	2364082	g58464	i0	64.6	2.60240963855422	48	17	86.7	0	15	158	359	406	MBX9951133.1 apolipoprotein N-acyltransferase [Candidatus Obscuribacterales bacterium]	diamond	432	73.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30439932	30439932	PRJNA414225_P_NODE_17273_length_190_cov_1.141844_g17186_i0	PRJNA414225	17273	190	1.141844	2.1695036	Cyanophyceae	3028117	Bacteria	Bacteria	117	1.26e-28	NR	BAZ44931.1	2005460	g17186	i0	90.3	1.95789473684211	62	6	97.9	0	188	3	185	246	BAZ44931.1 hypothetical protein NIES4102_19480 [Chondrocystis sp. NIES-4102]	diamond	372	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
30534485	30534485	PRJNA414225_P_NODE_78153_length_163_cov_0.894737_g78066_i0	PRJNA414225	78153	163	0.894737	1.45842131	Cyanophyceae	3028117	Bacteria	Bacteria	54.3	3.68e-7	NR	WP_374793322.1	1246629	g78066	i0	88.5	5.33742331288344	26	3	47.9	0	4	81	144	169	WP_374793322.1 MULTISPECIES: pentapeptide repeat-containing protein [Aerosakkonema]	diamond	870	54.7	0.992687385740402	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Aerosakkonema
31212570	31212570	PRJNA414225_P_NODE_90775_length_156_cov_2.084112_g90688_i0	PRJNA414225	90775	156	2.084112	3.25121472	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	103	5.72e-24	NR	MBS2002701.1	2807734	g90688	i0	100	0.980769230769231	51	0	98.1	0	3	155	385	435	MBS2002701.1 N-6 DNA methylase [Cyanobacteria bacterium SZAS LIN-5]	diamond	153	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5

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