metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA602115" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA602115" and tax_clade = "Amoebozoa"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27016595	27016595	PRJNA602115_P_NODE_11422_length_202_cov_0.907801_g11397_i0	PRJNA602115	11422	202	0.907801	1.83375802	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	42	0.0408	NR	XP_003286034.1	5786	g11397	i0	50	0.594059405940594	40	20	59.4	0	122	3	1098	1137	XP_003286034.1 uncharacterized protein DICPUDRAFT_149960 [Dictyostelium purpureum]	diamond	120	42	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
29713813	29713813	PRJNA602115_P_NODE_9630_length_207_cov_0.876712_g9605_i0	PRJNA602115	9630	207	0.876712	1.81479384	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82.4	1.98e-16	NR	XP_020433737.1	670386	g9605	i0	49.3	12.6376811594203	67	34	97.1	0	2	202	142	208	XP_020433737.1 heat shock protein DnaJ family protein [Heterostelium album PN500]	diamond	2616	82.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
30996270	30996270	PRJNA602115_P_NODE_6014_length_259_cov_1.292929_g5989_i0	PRJNA602115	6014	259	1.292929	3.34868611	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	103	6.79e-26	NR	XP_012758992.1	1410327	g5989	i0	60	0.984555984555985	85	34	98.5	0	256	2	1	85	XP_012758992.1 hypothetical protein SAMD00019534_001050 [Acytostelium subglobosum LB1]	diamond	255	103	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
32766514	32766514	PRJNA602115_P_NODE_8900_length_209_cov_0.864865_g8875_i0	PRJNA602115	8900	209	0.864865	1.80756785	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	45.4	0.00269	NR	KYR02864.1	361077	g8875	i0	38.5	2.22488038277512	52	29	71.8	2	11	160	437	487	KYR02864.1 G-protein-coupled receptor family 3 [Tieghemostelium lacteum]	diamond	465	45.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum

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