metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB11523" and tax_clade = "Cyanobacteriota/Melainabacteria group"

10 rows where analysis = "diamond", bioproject = "PRJEB11523" 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
12767311	12767311	PRJEB11523_P_NODE_651_length_747_cov_7.730659_g588_i0	PRJEB11523	651	747	7.730659	57.74802273	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	181	3.3e-54	NR	MBI3591835.1	2052166	g588	i0	78.6	0.469879518072289	117	25	47	0	745	395	9	125	MBI3591835.1 ribose 5-phosphate isomerase B [Candidatus Melainabacteria bacterium]	diamond	351	181	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26874852	26874852	PRJEB11523_P_NODE_2681_length_313_cov_2.806818_g2603_i0	PRJEB11523	2681	313	2.806818	8.78534034	Coleofasciculus chthonoplastes	64178	Bacteria	Bacteria	53.5	9.41e-6	NR	MEQ9372274.1	3069539	g2603	i0	40	0.623003194888179	65	38	62.3	1	22	216	162	225	MEQ9372274.1 FkbM family methyltransferase [Coleofasciculus chthonoplastes F3-SA18-01]	diamond	195	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
28232689	28232689	PRJEB11523_P_NODE_8486_length_162_cov_0.902655_g8408_i0	PRJEB11523	8486	162	0.902655	1.4623011	Chroococcus sp. CMT-3BRIN-NPC107	2499659	Bacteria	Bacteria	102	5.769999999999999e-24	NR	MBW4663111.1	2499659	g8408	i0	98.1	0.981481481481482	53	1	98.1	0	161	3	321	373	MBW4663111.1 purine permease [Chroococcus sp. CMT-3BRIN-NPC107]	diamond	159	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. CMT-3BRIN-NPC107
28517167	28517167	PRJEB11523_P_NODE_3567_length_258_cov_19.732057_g3489_i0	PRJEB11523	3567	258	19.732057	50.90870706	Tumidithrix elongata	3088357	Bacteria	Bacteria	63.9	1.44e-9	NR	WP_330485949.1	3088357	g3489	i0	47.3	0.86046511627907	74	38	84.9	1	244	26	280	353	WP_330485949.1 glycosyltransferase [Tumidithrix elongata]	diamond	222	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Tumidithrix	Tumidithrix elongata
28580343	28580343	PRJEB11523_P_NODE_8427_length_162_cov_1.327434_g8349_i0	PRJEB11523	8427	162	1.327434	2.15044308	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	89	3.22e-20	NR	MDD4528044.1	2053573	g8349	i0	81.1	0.981481481481482	53	10	98.1	0	3	161	23	75	MDD4528044.1 hypothetical protein [Candidatus Margulisiibacteriota bacterium]	diamond	159	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
30317660	30317660	PRJEB11523_P_NODE_6312_length_184_cov_1.133333_g6234_i0	PRJEB11523	6312	184	1.133333	2.08533272	Calothrix sp. UHCC	1187	Bacteria	Bacteria	122	8.2e-31	NR	WP_323338401.1	3110245	g6234	i0	91.7	4.89130434782609	60	5	97.8	0	3	182	505	564	WP_323338401.1 group II intron reverse transcriptase/maturase [Calothrix sp. UHCC 0171]	diamond	900	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. UHCC 0171
30753361	30753361	PRJEB11523_P_NODE_6474_length_181_cov_1.545455_g6396_i0	PRJEB11523	6474	181	1.545455	2.79727355	Spirulina	1154	Bacteria	Bacteria	101	1.18e-24	NR	NEO85007.1	2607816	g6396	i0	78	1.95580110497238	59	13	97.8	0	3	179	178	236	NEO85007.1 SDR family oxidoreductase [Spirulina sp. SIO3F2]	diamond	354	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp. SIO3F2
31163781	31163781	PRJEB11523_P_NODE_4215_length_232_cov_13.049180_g4137_i0	PRJEB11523	4215	232	13.04918	30.2740976	Bacteria	2	Bacteria	Bacteria	76.3	5e-14	NR	OGI20455.1	1801607	g4137	i0	56.1	1.47413793103448	57	25	73.7	0	210	40	351	407	OGI20455.1 MAG: hypothetical protein A3B68_02935 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	342	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
31802572	31802572	PRJEB11523_P_NODE_8437_length_162_cov_0.902655_g8359_i0	PRJEB11523	8437	162	0.902655	1.4623011	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	97.8	2.5299999999999998e-24	NR	WP_106368012.1	2107693	g8359	i0	87	2	54	7	100	0	162	1	58	111	WP_106368012.1 GNAT family N-acetyltransferase [Chlorogloea sp. CCALA 695]	diamond	324	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
32562386	32562386	PRJEB11523_P_NODE_6639_length_178_cov_2.813953_g6561_i0	PRJEB11523	6639	178	2.813953	5.00883634	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	79.3	1.65e-15	NR	MBX9570434.1	2364082	g6561	i0	63.8	2.93258426966292	58	21	97.8	0	176	3	158	215	MBX9570434.1 nucleotide sugar dehydrogenase [Candidatus Obscuribacterales bacterium]	diamond	522	79.3	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);;