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

12 rows where analysis = "diamond", bioproject = "PRJNA1126198" 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
11759656	11759656	PRJNA1126198_P_NODE_13690_length_543_cov_5.353191_g13009_i0	PRJNA1126198	13690	543	5.353191	29.06782713	Cyanobium sp. ARS6	2024869	Bacteria	Bacteria	219	1.28e-69	NR	CAI8350359.1	2024869	g13009	i0	70.3	2.45303867403315	148	44	81.8	0	508	65	46	193	CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6]	diamond	1332	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ARS6
13035126	13035126	PRJNA1126198_P_NODE_318851_length_261_cov_2.053191_g318130_i0	PRJNA1126198	318851	261	2.053191	5.35882851	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	124	6.879999999999999e-34	NR	WP_036481693.1	1541065	g318130	i0	64	18.6091954022989	86	31	98.9	0	260	3	17	102	WP_036481693.1 2-C-methyl-D-erythritol 2,4-cyclodiphosphate synthase [Myxosarcina sp. GI1]	diamond	4857	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Myxosarcina	Myxosarcina sp. GI1
27533345	27533345	PRJNA1126198_P_NODE_428123_length_246_cov_0.895954_g427402_i0	PRJNA1126198	428123	246	0.895954	2.20404684	Nostocales	1161	Bacteria	Bacteria	111	3.8500000000000006e-27	NR	WP_096595365.1	1954171	g427402	i0	65.9	2	82	28	100	0	246	1	156	237	WP_096595365.1 hypothetical protein [Calothrix sp. NIES-2098]	diamond	492	112	0.991071428571429	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-2098
28270212	28270212	PRJNA1126198_P_NODE_101446_length_341_cov_2.518657_g100727_i0	PRJNA1126198	101446	341	2.518657	8.58862037	Cyanobacteria bacterium SBC	2821503	Bacteria	Bacteria	139	6.829999999999999e-40	NR	MBP0003062.1	2821503	g100727	i0	61.2	13.108504398827	98	38	86.2	0	47	340	8	105	MBP0003062.1 phosphoribosyl-AMP cyclohydrolase [Cyanobacteria bacterium SBC]	diamond	4470	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SBC
28333553	28333553	PRJNA1126198_P_NODE_401406_length_248_cov_1.782857_g400685_i0	PRJNA1126198	401406	248	1.782857	4.42148536	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	81.6	4.21e-17	NR	MBL8086383.1	2711154	g400685	i0	73.6	0.641129032258065	53	14	64.1	0	236	78	92	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	159	81.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30544260	30544260	PRJNA1126198_P_NODE_422793_length_246_cov_1.710983_g422072_i0	PRJNA1126198	422793	246	1.710983	4.20901818	Limnospira platensis	118562	Bacteria	Bacteria	62.8	4.79e-10	NR	MDV7395346.1	3080829	g422072	i0	88.2	0.414634146341463	34	4	41.5	0	192	91	1	34	MDV7395346.1 hypothetical protein [Arthrospira platensis SPKY1]	diamond	102	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
30733742	30733742	PRJNA1126198_P_NODE_387994_length_250_cov_0.875706_g387273_i0	PRJNA1126198	387994	250	0.875706	2.189265	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	120	8.39e-31	NR	MCA0314599.1	2052166	g387273	i0	95.2	0.744	62	3	74.4	0	65	250	1	62	MCA0314599.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium]	diamond	186	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30765390	30765390	PRJNA1126198_P_NODE_422074_length_246_cov_1.791908_g421353_i0	PRJNA1126198	422074	246	1.791908	4.40809368	Candidatus Obscuribacter phosphatis	1906157	Bacteria	Bacteria	158	1.58e-44	NR	MBN8658814.1	1906157	g421353	i0	97.5	0.975609756097561	80	2	97.6	0	242	3	1	80	MBN8658814.1 amidohydrolase family protein [Candidatus Obscuribacter phosphatis]	diamond	240	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter phosphatis
31671235	31671235	PRJNA1126198_P_NODE_412977_length_247_cov_1.522989_g412256_i0	PRJNA1126198	412977	247	1.522989	3.76178283	Microcystis	1125	Bacteria	Bacteria	55.5	1.33e-6	NR	WP_272081035.1	1126	g412256	i0	52.8	28.7246963562753	72	27	86.2	2	241	29	741	806	WP_272081035.1 beta strand repeat-containing protein [Microcystis aeruginosa]	diamond	7095	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
31734336	31734336	PRJNA1126198_P_NODE_435997_length_245_cov_0.906977_g435276_i0	PRJNA1126198	435997	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	158	4.59e-45	NR	HAJ60538.1	2055766	g435276	i0	90.1	1.98367346938776	81	8	99.2	0	245	3	131	211	HAJ60538.1 glycosyl transferase, UDP-glucuronosyltransferase [Cyanobacteria bacterium UBA8543]	diamond	486	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA8543
32473308	32473308	PRJNA1126198_P_NODE_339339_length_257_cov_1.467391_g338618_i0	PRJNA1126198	339339	257	1.467391	3.77119487	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	175	4.87e-53	NR	MBX9672098.1	2364082	g338618	i0	98.8	0.992217898832685	85	1	99.2	0	256	2	129	213	MBX9672098.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	255	175	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32725501	32725501	PRJNA1126198_P_NODE_358420_length_253_cov_1.588889_g357699_i0	PRJNA1126198	358420	253	1.588889	4.01988917	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	164	3.47e-46	NR	MCA0316296.1	2052166	g357699	i0	100	0.99604743083004	84	0	99.6	0	253	2	338	421	MCA0316296.1 GntR family transcriptional regulator [Candidatus Melainabacteria bacterium]	diamond	252	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria 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);;