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

4 rows where analysis = "diamond", bioproject = "PRJNA893346" 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
26873841	26873841	PRJNA893346_P_NODE_27721_length_286_cov_1.084507_g27231_i0	PRJNA893346	27721	286	1.084507	3.10169002	Leptolyngbyaceae	1890438	Bacteria	Bacteria	42.7	0.0371	NR	WP_228016184.1	1202	g27231	i0	65.2	0.493006993006993	23	8	24.1	0	170	102	142	164	WP_228016184.1 sterol desaturase family protein [Leptolyngbya ectocarpi]	diamond	141	43.1	0.990719257540603	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya ectocarpi
28603167	28603167	PRJNA893346_P_NODE_17647_length_368_cov_4.345763_g17158_i0	PRJNA893346	17647	368	4.345763	15.99240784	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	139	3.58e-39	NR	WP_250122352.1	155894	g17158	i0	58.3	1.67934782608696	103	43	84	0	310	2	8	110	WP_250122352.1 pyridoxamine 5'-phosphate oxidase family protein [Chroococcidiopsis sp. CCMEE 29]	diamond	618	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
29581531	29581531	PRJNA893346_P_NODE_30710_length_267_cov_1.319588_g30220_i0	PRJNA893346	30710	267	1.319588	3.52329996	Candidatus Gastranaerophilaceae bacterium	3022870	Bacteria	Bacteria	129	4.69e-36	NR	MEI3269784.1	3022870	g30220	i0	76.6	10.561797752809	77	18	86.5	0	263	33	3	79	MEI3269784.1 O-acetyl-ADP-ribose deacetylase [Candidatus Gastranaerophilaceae bacterium]	diamond	2820	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales	Candidatus Gastranaerophilaceae		Candidatus Gastranaerophilaceae bacterium
30157916	30157916	PRJNA893346_P_NODE_24232_length_310_cov_1.236287_g23742_i0	PRJNA893346	24232	310	1.236287	3.8324897	Pseudanabaena	1152	Bacteria	Bacteria	67.4	6.87e-11	NR	MFN5613299.1	1153	g23742	i0	42.2	4.94516129032258	102	56	97.7	3	3	305	129	228	MFN5613299.1 DUF3474 domain-containing protein [Pseudanabaena sp.]	diamond	1533	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.

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