metadata: contig_metadata: 5 rows where bioproject = "PRJNA983848", tax_clade = "Amoebozoa" and tax

5 rows where bioproject = "PRJNA983848", tax_clade = "Amoebozoa" and tax_phylum = "Evosea"

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
4798228	4798228	PRJNA983848_P_NODE_68484_length_384_cov_1.266881_g62601_i0	PRJNA983848	68484	384	1.266881	4.86482304	Heterostelium album	2086695	Evosea	other_Eukaryota	56.5	0.003	NTclustered	gi\|1160566688\|ref\|XM_020580969.1\|	670386	g62601	i0	90.698	0.552083333333333	43	3	11	1	169	211	74	33	Polysphondylium pallidum PN500 hypothetical protein partial mRNA	blastn	212	56.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
7348889	7348889	PRJNA983848_P_NODE_89226_length_324_cov_1.498008_g83343_i0	PRJNA983848	89226	324	1.498008	4.85354592	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	58.4	6.54e-4	NTclustered	gi\|66806844\|ref\|XM_632053.1\|	352472	g83343	i0	100	3.51543209876543	31	0	10	0	293	323	1666	1636	Dictyostelium discoideum AX4 myb domain-containing protein (mybD) mRNA, complete cds	blastn	1139	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
21373481	21373481	PRJNA983848_P_NODE_96437_length_309_cov_2.105932_g90554_i0	PRJNA983848	96437	309	2.105932	6.50732988	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	54.7	0.008	NTclustered	gi\|330795564\|ref\|XM_003285795.1\|	5786	g90554	i0	100	0.184466019417476	29	0	9	0	18	46	1494	1522	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_97185), partial mRNA	blastn	57	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
27057965	27057965	PRJNA983848_P_NODE_74222_length_363_cov_2.406897_g68339_i0	PRJNA983848	74222	363	2.406897	8.73703611	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	44.7	0.0283	NR	KAF2070681.1	133409	g68339	i0	40	0.413223140495868	50	30	41.3	0	91	240	105	154	KAF2070681.1 hypothetical protein CYY_008007 [Polysphondylium violaceum]	diamond	150	44.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
28358680	28358680	PRJNA983848_P_NODE_114666_length_280_cov_2.183575_g108783_i0	PRJNA983848	114666	280	2.183575	6.11401	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	122	1.3899999999999999e-31	NR	XP_003290234.1	5786	g108783	i0	66.7	5.775	90	30	96.4	0	2	271	201	290	XP_003290234.1 uncharacterized protein DICPUDRAFT_95090 [Dictyostelium purpureum]	diamond	1617	122	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum

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