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

9 rows where analysis = "diamond", bioproject = "PRJNA781196" 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
11415054	11415054	PRJNA781196_P_NODE_14269_length_434_cov_7.875346_g13892_i0	PRJNA781196	14269	434	7.875346	34.17900164	Cyanophyceae	3028117	Bacteria	Bacteria	227	5.73e-74	NR	WP_190670235.1	2692825	g13892	i0	76.6	15.5668202764977	141	33	97.5	0	423	1	2	142	WP_190670235.1 nucleoside-diphosphate kinase [Microcoleus sp. FACHB-672]	diamond	6756	229	0.991266375545852	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-672
13512936	13512936	PRJNA781196_P_NODE_26751_length_335_cov_1.786260_g26374_i0	PRJNA781196	26751	335	1.78626	5.983971	root	1	Root_unresolved	Root_unresolved	183	3.5e-53	NR	OWY73533.1	1503470	g26374	i0	81.1	20.8746268656716	111	21	99.4	0	335	3	200	310	OWY73533.1 adenosylhomocysteinase [cyanobacterium TDX16]	diamond	6993	184	0.994565217391304	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16
27338117	27338117	PRJNA781196_P_NODE_55743_length_249_cov_1.159091_g55366_i0	PRJNA781196	55743	249	1.159091	2.88613659	Synechococcus sp. NOUM97	1131	Bacteria	Bacteria	42.7	0.0389	NR	WP_186479849.1	1442555	g55366	i0	36.6	0.855421686746988	71	41	85.5	1	231	19	63	129	WP_186479849.1 GTPase ObgE [Synechococcus sp. NOUM97013]	diamond	213	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. NOUM97013
27464492	27464492	PRJNA781196_P_NODE_62383_length_245_cov_0.906977_g62006_i0	PRJNA781196	62383	245	0.906977	2.22209365	Nostoc sp. DedQUE01	3075387	Bacteria	Bacteria	63.9	1.82e-10	NR	MFN6501164.1	3075387	g62006	i0	34.7	0.918367346938776	75	49	91.8	0	225	1	6	80	MFN6501164.1 TerB family tellurite resistance protein [Nostoc sp. DedQUE01]	diamond	225	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. DedQUE01
27884135	27884135	PRJNA781196_P_NODE_61185_length_246_cov_0.901734_g60808_i0	PRJNA781196	61185	246	0.901734	2.21826564	Cyanophyceae	3028117	Bacteria	Bacteria	47.4	8.5e-4	NR	WP_066119880.1	1617448	g60808	i0	27.8	4.86585365853659	79	56	95.1	1	245	12	259	337	WP_066119880.1 mechanosensitive ion channel family protein [Geminocystis sp. NIES-3709]	diamond	1197	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709
30748679	30748679	PRJNA781196_P_NODE_66974_length_242_cov_0.923077_g66597_i0	PRJNA781196	66974	242	0.923077	2.23384634	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	90.9	3.88e-19	NR	MBW4503829.1	1939789	g66597	i0	51.3	3	80	39	99.2	0	242	3	186	265	MBW4503829.1 NAD(P)-binding protein [Scytonema hyalinum WJT4-NPBG1]	diamond	726	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
31190608	31190608	PRJNA781196_P_NODE_59315_length_247_cov_0.896552_g58938_i0	PRJNA781196	59315	247	0.896552	2.21448344	Nostoc sp. CCY0012	1056123	Bacteria	Bacteria	58.2	3.92e-8	NR	WP_414543588.1	1056123	g58938	i0	48.2	0.680161943319838	56	28	68	1	73	240	48	102	WP_414543588.1 DUF4174 domain-containing protein [Nostoc sp. CCY0012]	diamond	168	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CCY0012
31254147	31254147	PRJNA781196_P_NODE_49735_length_253_cov_1.316667_g49358_i0	PRJNA781196	49735	253	1.316667	3.33116751	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	114	1.54e-29	NR	MBW4638347.1	2839657	g49358	i0	74.7	0.984189723320158	83	21	98.4	0	251	3	75	157	MBW4638347.1 DUF305 domain-containing protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	249	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32424719	32424719	PRJNA781196_P_NODE_36119_length_296_cov_0.959641_g35742_i0	PRJNA781196	36119	296	0.959641	2.84053736	Calothrix sp. NIES-21	1187	Bacteria	Bacteria	50.1	1.65e-4	NR	WP_096603467.1	1954172	g35742	i0	42	1.53040540540541	50	29	50.7	0	10	159	8	57	WP_096603467.1 WD40 repeat domain-containing protein [Calothrix sp. NIES-2100]	diamond	453	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-2100

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