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

5 rows where analysis = "diamond", bioproject = "PRJEB75227" 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	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
6098841	6098841	PRJEB75227_P_NODE_6385_length_281_cov_3.697115_g6214_i0	PRJEB75227	6385	281	3.697115	10.38889315	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	157	2.7499999999999993e-42	NR	MCC6977306.1	2052166	g6214	i0	94.2	0.918149466192171	86	5	91.8	3	260	57	142	MCC6977306.1 transglycosylase SLT domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	258	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29465367	29465367	PRJEB75227_P_NODE_10830_length_245_cov_0.906977_g10659_i0	PRJEB75227	10830	245	0.906977	2.22209365	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	127	8.429999999999998e-32	NR	MBW4639597.1	2839657	g10659	i0	75.3	0.991836734693878	81	20	99.2	244	2	110	190	MBW4639597.1 GAF domain-containing protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	243	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32271668	32271668	PRJEB75227_P_NODE_11198_length_244_cov_0.912281_g11027_i0	PRJEB75227	11198	244	0.912281	2.22596564	Nostocales	1161	Bacteria	Bacteria	125	1.2199999999999999e-32	NR	WP_099071069.1	92942	g11027	i0	77.2	4.83196721311475	79	18	97.1	3	239	100	178	WP_099071069.1 D-alanine--D-alanine ligase family protein [Nostoc linckia]	diamond	1179	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc linckia
32689381	32689381	PRJEB75227_P_NODE_5940_length_288_cov_1.339535_g5769_i0	PRJEB75227	5940	288	1.339535	3.8578608	Calothrix sp. FI2-JRJ7	2839656	Bacteria	Bacteria	103	3.96e-25	NR	MBW4600929.1	2839656	g5769	i0	55.8	0.989583333333333	95	42	99	285	1	6	100	MBW4600929.1 pentapeptide repeat-containing protein [Calothrix sp. FI2-JRJ7]	diamond	285	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. FI2-JRJ7
32713726	32713726	PRJEB75227_P_NODE_8500_length_252_cov_0.871508_g8329_i0	PRJEB75227	8500	252	0.871508	2.19620016	Cyanophyceae	3028117	Bacteria	Bacteria	105	3.5e-24	NR	HEY9668083.1	3081323	g8329	i0	68.1	4.35714285714286	72	23	85.7	36	251	29	100	HEY9668083.1 filamentous hemagglutinin N-terminal domain-containing protein [Coleofasciculaceae cyanobacterium]	diamond	1098	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium

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