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

14 rows where analysis = "diamond", bioproject = "PRJNA1226487" 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
10538772	10538772	PRJNA1226487_P_NODE_269_length_1443_cov_16.469343_g234_i0	PRJNA1226487	269	1443	16.469343	237.65261949	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	295	1.29e-94	NR	WP_190487424.1	2692827	g234	i0	82.9	0.461538461538462	222	15	41.4	1	1285	689	1	222	WP_190487424.1 hypothetical protein [Microcoleus sp. FACHB-831]	diamond	666	295	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
12525494	12525494	PRJNA1226487_P_NODE_13530_length_406_cov_5.387387_g13429_i0	PRJNA1226487	13530	406	5.387387	21.87279122	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	88.2	2.67e-17	NR	MBX9686550.1	2364082	g13429	i0	58.2	0.583743842364532	79	32	58.4	1	2	238	427	504	MBX9686550.1 NADH-quinone oxidoreductase subunit NuoN [Candidatus Obscuribacterales bacterium]	diamond	237	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
26660925	26660925	PRJNA1226487_P_NODE_2421_length_712_cov_1.666667_g2333_i0	PRJNA1226487	2421	712	1.666667	11.86666904	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	443	2.29e-150	NR	MBX9685847.1	2364082	g2333	i0	93.1	2.94943820224719	233	16	98.2	0	10	708	149	381	MBX9685847.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Obscuribacterales bacterium]	diamond	2100	443	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27154300	27154300	PRJNA1226487_P_NODE_52262_length_269_cov_1.571429_g52160_i0	PRJNA1226487	52262	269	1.571429	4.22714401	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	105	5.13e-24	NR	WP_094533621.1	1980935	g52160	i0	55.2	2.82156133828996	87	39	97	0	264	4	407	493	WP_094533621.1 glycosyltransferase [Pseudanabaena sp. SR411]	diamond	759	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. SR411
28430884	28430884	PRJNA1226487_P_NODE_46286_length_278_cov_3.595122_g46184_i0	PRJNA1226487	46286	278	3.595122	9.99443916	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	73.6	7.81e-13	NR	MBX9669965.1	2364082	g46184	i0	66.7	0.58273381294964	54	18	58.3	0	8	169	385	438	MBX9669965.1 B12-binding domain-containing radical SAM protein [Candidatus Obscuribacterales bacterium]	diamond	162	73.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28525667	28525667	PRJNA1226487_P_NODE_64447_length_251_cov_0.865169_g64345_i0	PRJNA1226487	64447	251	0.865169	2.17157419	Myxacorys chilensis	2594884	Bacteria	Bacteria	171	3.66e-49	NR	MBW4542269.1	1601998	g64345	i0	97.6	0.99203187250996006	83	2	99.2	0	1	249	153	235	MBW4542269.1 IctB family putative bicarbonate transporter [Myxacorys chilensis ATA2-1-KO14]	diamond	249	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Myxacorys	Myxacorys chilensis
28777942	28777942	PRJNA1226487_P_NODE_2087_length_744_cov_4.038748_g2000_i0	PRJNA1226487	2087	744	4.038748	30.04828512	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	464	5.17e-147	NR	WP_190484093.1	2692827	g2000	i0	90.2	1.98387096774194	246	24	99.2	0	740	3	1567	1812	WP_190484093.1 PAS domain S-box protein [Microcoleus sp. FACHB-831]	diamond	1476	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
29870363	29870363	PRJNA1226487_P_NODE_16891_length_379_cov_7.192810_g16789_i0	PRJNA1226487	16891	379	7.19281	27.2607499	Bacteria	2	Bacteria	Bacteria	105	1.1199999999999999e-23	NR	WP_002806085.1	1219	g16789	i0	60.5	10.9630606860158	81	31	63.3	1	374	135	405	485	WP_002806085.1 PLP-dependent transferase [Prochlorococcus marinus]	diamond	4155	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
30344835	30344835	PRJNA1226487_P_NODE_25232_length_335_cov_15.206107_g25130_i0	PRJNA1226487	25232	335	15.206107	50.94045845	Planktothrix	54304	Bacteria	Bacteria	107	5.0399999999999995e-25	NR	MBS1994928.1	2807731	g25130	i0	56.1	1.60298507462687	82	36	73.4	0	247	2	54	135	MBS1994928.1 patatin-like phospholipase family protein [Cyanobacteria bacterium SZAS LIN-2]	diamond	537	108	0.990740740740741	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-2
31273450	31273450	PRJNA1226487_P_NODE_31535_length_312_cov_3.497908_g31433_i0	PRJNA1226487	31535	312	3.497908	10.91347296	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	48.1	0.00105	NR	MBX9572330.1	2364082	g31433	i0	25.7	0.971153846153846	101	75	97.1	0	6	308	332	432	MBX9572330.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	303	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31969248	31969248	PRJNA1226487_P_NODE_52578_length_268_cov_5.558974_g52476_i0	PRJNA1226487	52578	268	5.558974	14.89805032	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	45.4	0.00545	NR	MBX9691382.1	2847862	g52476	i0	51.3	0.436567164179104	39	19	43.7	0	151	35	1	39	MBX9691382.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	117	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32254447	32254447	PRJNA1226487_P_NODE_20338_length_358_cov_20.045614_g20236_i0	PRJNA1226487	20338	358	20.045614	71.76329812	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	222	2.13e-66	NR	MBX9572578.1	2364082	g20236	i0	96.6	1.94413407821229	116	4	97.2	0	350	3	357	472	MBX9572578.1 Flp pilus assembly complex ATPase component TadA [Candidatus Obscuribacterales bacterium]	diamond	696	222	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32412426	32412426	PRJNA1226487_P_NODE_14579_length_397_cov_4.074074_g14477_i0	PRJNA1226487	14579	397	4.074074	16.17407378	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	228	3.46e-66	NR	WP_190484093.1	2692827	g14477	i0	93.8	0.982367758186398	130	8	98.2	0	395	6	1801	1930	WP_190484093.1 PAS domain S-box protein [Microcoleus sp. FACHB-831]	diamond	390	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
32633214	32633214	PRJNA1226487_P_NODE_540_length_1166_cov_4.419945_g490_i0	PRJNA1226487	540	1166	4.419945	51.5365587	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	399	2.46e-135	NR	WP_190490872.1	2692827	g490	i0	92	0.576329331046312	224	18	57.6	0	676	5	1	224	WP_190490872.1 DUF2382 domain-containing protein [Microcoleus sp. FACHB-831]	diamond	672	399	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831

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