metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA615175" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA615175" and tax_phylum = "Cyanobacteriota"

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
12074040	12074040	PRJNA615175_P_NODE_10550_length_450_cov_3.671088_g10382_i0	PRJNA615175	10550	450	3.671088	16.519896	Fortiea sp. LEGE XX443	1828611	Bacteria	Bacteria	89.7	9.55e-18	NR	WP_193885198.1	1828611	g10382	i0	34.9	4.52666666666667	149	94	98	2	449	9	213	360	WP_193885198.1 FAD-dependent oxidoreductase [Fortiea sp. LEGE XX443]	diamond	2037	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Fortieaceae	Fortiea	Fortiea sp. LEGE XX443
27649086	27649086	PRJNA615175_P_NODE_36124_length_226_cov_3.895425_g35956_i0	PRJNA615175	36124	226	3.895425	8.8036605	Thermoleptolyngbya sp. C42_A2	3100228	Bacteria	Bacteria	139	2.4999999999999996e-38	NR	WP_297084203.1	2747799	g35956	i0	91.9	0.982300884955752	74	6	98.2	0	224	3	75	148	WP_297084203.1 AraC family transcriptional regulator [Thermoleptolyngbya sp. C42_A2020_037]	diamond	222	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya sp. C42_A2020_037
27680862	27680862	PRJNA615175_P_NODE_19844_length_312_cov_1.288703_g19676_i0	PRJNA615175	19844	312	1.288703	4.02075336	Phormidium tenue	126344	Bacteria	Bacteria	149	4.42e-42	NR	MBD3883789.1	2692911	g19676	i0	94.7	0.721153846153846	75	4	72.1	0	1	225	211	285	MBD3883789.1 aldose epimerase [Phormidium tenue FACHB-886]	diamond	225	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium tenue
28324937	28324937	PRJNA615175_P_NODE_4666_length_716_cov_3.928460_g4506_i0	PRJNA615175	4666	716	3.92846	28.1277736	Bacteria	2	Bacteria	Bacteria	86.3	3.13e-15	NR	NET09805.1	2607785	g4506	i0	32.5	4.55446927374302	169	86	70.4	4	26	529	825	966	NET09805.1 response regulator [Symploca sp. SIO2B6]	diamond	3261	86.7	0.995386389850058	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Symploca	Symploca sp. SIO2B6
29700906	29700906	PRJNA615175_P_NODE_24870_length_272_cov_1.547739_g24702_i0	PRJNA615175	24870	272	1.547739	4.20985008	Aliterella atlantica	1827278	Bacteria	Bacteria	134	1.2699999999999998e-35	NR	WP_045056602.1	1827278	g24702	i0	100	0.738970588235294	67	0	73.9	0	270	70	332	398	WP_045056602.1 response regulator [Aliterella atlantica]	diamond	201	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31060066	31060066	PRJNA615175_P_NODE_16455_length_347_cov_1.058394_g16287_i0	PRJNA615175	16455	347	1.058394	3.67262718	Synechococcales cyanobacterium T60_A2020_003	2774349	Bacteria	Bacteria	48.5	0.00112	NR	MBF2080596.1	2774349	g16287	i0	38.2	1.57348703170029	76	40	65.7	2	229	2	489	557	MBF2080596.1 SBBP repeat-containing protein [Synechococcales cyanobacterium T60_A2020_003]	diamond	546	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			Synechococcales cyanobacterium T60_A2020_003
31249322	31249322	PRJNA615175_P_NODE_21615_length_297_cov_1.191964_g21447_i0	PRJNA615175	21615	297	1.191964	3.54013308	Dulcicalothrix desertica	32056	Bacteria	Bacteria	117	9.69e-29	NR	WP_127084487.1	32056	g21447	i0	52.4	6.34343434343434	103	44	99	1	294	1	7	109	WP_127084487.1 threonine--tRNA ligase [Dulcicalothrix desertica]	diamond	1884	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
31312611	31312611	PRJNA615175_P_NODE_415_length_1862_cov_5.830632_g378_i0	PRJNA615175	415	1862	5.830632	108.56636784	Leptolyngbyaceae cyanobacterium M33_DOE_097	2747805	Bacteria	Bacteria	153	9.56e-35	NR	HIK14036.1	2747805	g378	i0	38.2	1.98657357679914	220	126	33.8	4	630	1	1492	1711	HIK14036.1 AAA family ATPase [Leptolyngbyaceae cyanobacterium M33_DOE_097]	diamond	3699	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium M33_DOE_097
31768412	31768412	PRJNA615175_P_NODE_117_length_2642_cov_3.584274_g109_i0	PRJNA615175	117	2642	3.584274	94.69651908	Scytonema	1203	Bacteria	Bacteria	551	5.829999999999998e-178	NR	WP_190767560.1	3028117	g109	i0	37.9	7.34784254352763	934	485	99.8	20	5	2641	83	976	WP_190767560.1 MULTISPECIES: ATP-binding protein [Cyanophyceae]	diamond	19413	551	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
31850285	31850285	PRJNA615175_P_NODE_2117_length_1052_cov_1.977528_g2001_i0	PRJNA615175	2117	1052	1.977528	20.80359456	Fischerella sp. PCC 96	1191	Bacteria	Bacteria	50.1	0.0155	NR	WP_026735542.1	1173024	g2001	i0	47.5	0.114068441064639	40	21	11.4	0	10	129	622	661	WP_026735542.1 NB-ARC domain-containing protein [Fischerella sp. PCC 9605]	diamond	120	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. PCC 9605
32591112	32591112	PRJNA615175_P_NODE_2879_length_915_cov_9.035629_g2746_i0	PRJNA615175	2879	915	9.035629	82.67600535	Cyanophyceae	3028117	Bacteria	Bacteria	182	3.71e-50	NR	MBW4538789.1	1601998	g2746	i0	44	3.21967213114754	248	104	69.8	8	3	641	45	292	MBW4538789.1 erythromycin esterase family protein [Myxacorys chilensis ATA2-1-KO14]	diamond	2946	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Myxacorys	Myxacorys chilensis

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