metadata: contig_metadata: 7 rows where bioproject = "PRJNA602115" and tax

7 rows where 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
7520745	7520745	PRJNA602115_P_NODE_1366_length_506_cov_5.734831_g1341_i0	PRJNA602115	1366	506	5.734831	29.01824486	Vannellidae	95227	Discosea	other_Eukaryota	806	0	NTclustered	gi\|399764204\|gb\|JQ271715.1\|	1217115	g1341	i0	95.481	101.122529644269	509	16	100	6	1	506	1687	1183	Ripella sp. GP2 18S ribosomal RNA gene, partial sequence	blastn	51168	808	0.997524752475248	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. GP2
14604584	14604584	PRJNA602115_P_NODE_2772_length_363_cov_1.172185_g2747_i0	PRJNA602115	2772	363	1.172185	4.25503155	Badhamia sp. FYZ-2019a	2592590	Evosea	other_Eukaryota	353	8.429999999999997e-93	NTclustered	gi\|1818990597\|gb\|MN128540.1\|	2592590	g2747	i0	84.254	98.5123966942149	362	57	99	0	1	362	627	266	Badhamia sp. FYZ-2019a voucher SM2015091702 elongation factor 1-alpha (ef1alpha) gene, partial cds	blastn	35760	353	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Badhamia	Badhamia sp. FYZ-2019a
23528067	23528067	PRJNA602115_P_NODE_159_length_1439_cov_16.998549_g148_i0	PRJNA602115	159	1439	16.998549	244.60912011	Ripella sp. 805	1217113	Discosea	other_Eukaryota	1628	0	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g148	i0	94.502	74.1341209173037	1055	44	73	10	387	1438	1	1044	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	106679	1628	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
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);;