metadata: contig_metadata: 6 rows where bioproject = "PRJNA1197996" and tax

6 rows where bioproject = "PRJNA1197996" 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
4871744	4871744	PRJNA1197996_S_NODE_24944_length_248_cov_0.880000_g24890_i0	PRJNA1197996	24944	248	0.88	2.1824	Physaraceae	1115744	Evosea	other_Eukaryota	204	5.849999999999999e-48	NTclustered	gi\|374255710\|emb\|HE614610.2\|	227449	g24890	i0	82.573	32.0967741935484	241	32	95	8	1	235	1389	1153	Badhamia gracilis partial 18S rRNA gene, strain Az4-1	blastn	7960	204	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Badhamia	Badhamia gracilis
6702007	6702007	PRJNA1197996_S_NODE_26106_length_246_cov_0.890173_g26052_i0	PRJNA1197996	26106	246	0.890173	2.18982558	Vannella sp. strain CH88/I	325078	Discosea	other_Eukaryota	392	1.15e-104	NTclustered	gi\|62865937\|gb\|AY929912.1\|	325078	g26052	i0	99.535	60.2682926829268	215	1	87	0	1	215	398	184	Vannella sp. strain CH88/I 18S small subunit ribosomal RNA gene, partial sequence	blastn	14826	392	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. strain CH88/I
24550350	24550350	PRJNA1197996_S_NODE_28700_length_241_cov_0.916667_g28646_i0	PRJNA1197996	28700	241	0.916667	2.20916747	Physarum polycephalum	5791	Evosea	other_Eukaryota	254	5.54e-63	NTclustered	gi\|5764666\|gb\|AF177283.1\|AF177283	5791	g28646	i0	85.833	2.37759336099585	240	32	99	2	1	239	227	465	Physarum polycephalum putative ribosomal protein S11 mRNA, partial cds	blastn	573	254	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
28114655	28114655	PRJNA1197996_S_NODE_21145_length_261_cov_1.851064_g21091_i0	PRJNA1197996	21145	261	1.851064	4.83127704	Entamoeba invadens IP1	370355	Evosea	other_Eukaryota	45.4	0.00484	NR	XP_004259952.1	370355	g21091	i0	40	0.689655172413793	60	35	69	1	50	229	5	63	XP_004259952.1 protein disulfide isomerase, putative [Entamoeba invadens IP1]	diamond	180	45.4	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens
29144382	29144382	PRJNA1197996_S_NODE_5709_length_398_cov_2.132308_g5655_i0	PRJNA1197996	5709	398	2.132308	8.48658584	root	1	Root_unresolved	Root_unresolved	95.9	5.25e-20	NR	PRP75618.1	1890364	g5655	i0	57	2.93969849246231	79	33	58.8	1	1	234	565	643	PRP75618.1 hypothetical protein PROFUN_07984 [Planoprotostelium fungivorum]	diamond	1170	95.9	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30167134	30167134	PRJNA1197996_S_NODE_19612_length_268_cov_1.974359_g19558_i0	PRJNA1197996	19612	268	1.974359	5.29128212	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	68.6	4.23e-12	NR	XP_004362647.1	261658	g19558	i0	56	1.07462686567164	50	22	56	0	268	119	114	163	XP_004362647.1 eukaryotic translation initiation factor 5A [Cavenderia fasciculata]	diamond	288	68.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata

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