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

5 rows where analysis = "diamond", bioproject = "PRJNA699078" 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
28061776	28061776	PRJNA699078_S_NODE_87565_length_179_cov_1.200000_g86616_i0	PRJNA699078	87565	179	1.2	2.148	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	53.1	6.45e-7	NR	MFA5875369.1	2053573	g86616	i0	60	0.670391061452514	40	16	67	0	122	3	32	71	MFA5875369.1 RNA-binding protein [Candidatus Margulisiibacteriota bacterium]	diamond	120	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
28946180	28946180	PRJNA699078_S_NODE_23628_length_350_cov_1.524917_g22679_i0	PRJNA699078	23628	350	1.524917	5.3372095	Pleurocapsales cyanobacterium LEGE 06147	1828827	Bacteria	Bacteria	144	3.03e-37	NR	MBE9169993.1	1828827	g22679	i0	55.2	2.98285714285714	116	45	99.4	1	350	3	361	469	MBE9169993.1 bifunctional acetaldehyde-CoA/alcohol dehydrogenase [Pleurocapsales cyanobacterium LEGE 06147]	diamond	1044	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			Pleurocapsales cyanobacterium LEGE 06147
29009455	29009455	PRJNA699078_S_NODE_104788_length_164_cov_1.165217_g103839_i0	PRJNA699078	104788	164	1.165217	1.91095588	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	41.2	0.0229	NR	MBR2069296.1	2137880	g103839	i0	42	0.914634146341463	50	27	91.5	1	4	153	80	127	MBR2069296.1 cytidine deaminase [Candidatus Gastranaerophilales bacterium]	diamond	150	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
30430656	30430656	PRJNA699078_S_NODE_65693_length_208_cov_2.125786_g64744_i0	PRJNA699078	65693	208	2.125786	4.42163488	Geminocystis sp. GBBB	2664100	Bacteria	Bacteria	42.4	0.0329	NR	WP_308254607.1	2604140	g64744	i0	28.1	0.923076923076923	64	46	92.3	0	207	16	435	498	WP_308254607.1 group II intron reverse transcriptase/maturase [Geminocystis sp. GBBB08]	diamond	192	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. GBBB08
31251736	31251736	PRJNA699078_S_NODE_56595_length_226_cov_1.491525_g55646_i0	PRJNA699078	56595	226	1.491525	3.3708465	Cyanobacteria bacterium J06638_20	3023208	Bacteria	Bacteria	48.9	1.89e-4	NR	MEO1211654.1	3023208	g55646	i0	36.4	0.730088495575221	55	35	73	0	176	12	333	387	MEO1211654.1 reverse transcriptase family protein [Cyanobacteria bacterium J06638_20]	diamond	165	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06638_20

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