metadata: contig_metadata: 13 rows where bioproject = "PRJDB4470" and tax

13 rows where bioproject = "PRJDB4470" 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
9437	9437	PRJDB4470_P_NODE_33541_length_389_cov_3.502941_g32392_i0	PRJDB4470	33541	389	3.502941	13.62644049	Coremiostelium polycephalum	142831	Evosea	other_Eukaryota	93.5	2.19e-14	NTclustered	gi\|85062629\|gb\|DQ340387.1\|	142831	g32392	i0	88.312	20.853470437018	77	9	20	0	31	107	12524	12448	Dictyostelium polycephalum 17S ribosomal RNA, 5.8S ribosomal RNA, and 26S ribosomal RNA genes, complete sequence	blastn	8112	93.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales		Coremiostelium	Coremiostelium polycephalum
1284196	1284196	PRJDB4470_P_NODE_91742_length_180_cov_1.938931_g90587_i0	PRJDB4470	91742	180	1.938931	3.4900758	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	52.8	0.015	NTclustered	gi\|831786596\|ref\|XM_012902707.1\|	1410327	g90587	i0	100	0.155555555555556	28	0	16	0	29	56	2881	2908	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
2559268	2559268	PRJDB4470_P_NODE_32763_length_395_cov_16.485549_g31615_i0	PRJDB4470	32763	395	16.485549	65.11791855	Paramoeba pemaquidensis	180228	Discosea	other_Eukaryota	97.1	1.72e-15	NTclustered	gi\|145386790\|gb\|EF216915.1\|	180228	g31615	i0	84.158	15.6	101	15	26	1	1	101	351	252	Paramoeba pemaquidensis strain PA027 28S large subunit ribosomal RNA gene, partial sequence	blastn	6162	97.1	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba pemaquidensis
3835307	3835307	PRJDB4470_P_NODE_119304_length_163_cov_0.894737_g118149_i0	PRJDB4470	119304	163	0.894737	1.45842131	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	231	1.63e-56	NTclustered	gi\|470522915\|ref\|XM_004354431.1\|	1257118	g118149	i0	92.593	0.993865030674847	162	11	99	1	1	162	933	773	Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_026850), partial mRNA	blastn	162	231	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
17861402	17861402	PRJDB4470_P_NODE_51475_length_283_cov_1.777778_g50321_i0	PRJDB4470	51475	283	1.777778	5.03111174	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	412	1.0399999999999998e-110	NTclustered	gi\|470509685\|ref\|XM_004351027.1\|	1257118	g50321	i0	92.933	1	283	20	100	0	1	283	625	343	Acanthamoeba castellanii str. Neff Syntaxin7A, putative (ACA1_080580), partial mRNA	blastn	283	412	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
22960960	22960960	PRJDB4470_P_NODE_102339_length_168_cov_0.873950_g101184_i0	PRJDB4470	102339	168	0.87395	1.468236	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	52.8	0.014	NTclustered	gi\|66825574\|ref\|XM_641050.1\|	352472	g101184	i0	100	0.166666666666667	28	0	17	0	61	88	384	411	Dictyostelium discoideum AX4 hypothetical protein (DDB_G0269646) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
27885320	27885320	PRJDB4470_P_NODE_72865_length_214_cov_1.163636_g71710_i0	PRJDB4470	72865	214	1.163636	2.49018104	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	83.2	2.09e-18	NR	XP_004333881.1	1257118	g71710	i0	49.3	1.02336448598131	73	35	99.5	2	214	2	42	114	XP_004333881.1 Hypothetical protein ACA1_273800 [Acanthamoeba castellanii str. Neff]	diamond	219	83.2	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28580082	28580082	PRJDB4470_P_NODE_57587_length_258_cov_3.014354_g56432_i0	PRJDB4470	57587	258	3.014354	7.77703332	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	42	0.0377	NR	KAH3764260.1	1580589	g56432	i0	34.9	0.732558139534884	63	41	73.3	0	69	257	43	105	KAH3764260.1 hypothetical protein Pelo_3878 [Pelomyxa schiedti]	diamond	189	42	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
29022403	29022403	PRJDB4470_P_NODE_97748_length_172_cov_1.658537_g96593_i0	PRJDB4470	97748	172	1.658537	2.85268364	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	113	2.29e-27	NR	PRP84059.1	1890364	g96593	i0	89.5	0.994186046511628	57	6	99.4	0	1	171	771	827	PRP84059.1 hypothetical protein PROFUN_08521 [Planoprotostelium fungivorum]	diamond	171	113	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
29678817	29678817	PRJDB4470_P_NODE_56090_length_264_cov_1.767442_g54935_i0	PRJDB4470	56090	264	1.767442	4.66604688	Eumycetozoa	142796	Evosea	other_Eukaryota	147	8.959999999999997e-43	NR	P34729.1	5791	g54935	i0	80.2	2.93181818181818	86	17	97.7	0	3	260	81	166	P34729.1 RecName: Full=Ras-like protein 1; Flags: Precursor [Physarum polycephalum]	diamond	774	147	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
31327958	31327958	PRJDB4470_P_NODE_119016_length_163_cov_0.912281_g117861_i0	PRJDB4470	119016	163	0.912281	1.48701803	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	51.2	1.3e-5	NR	PRP85379.1	1890364	g117861	i0	58.3	0.662576687116564	36	15	66.3	0	2	109	679	714	PRP85379.1 acyl-coenzyme A thioesterase 9, mitochondrial-like [Planoprotostelium fungivorum]	diamond	108	51.2	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
31549689	31549689	PRJDB4470_P_NODE_5996_length_974_cov_3.250811_g5333_i0	PRJDB4470	5996	974	3.250811	31.66289914	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	126	3.9899999999999997e-28	NR	XP_004353575.1	1257118	g5333	i0	40.1	0.54517453798768	177	86	53.6	2	551	30	354	513	XP_004353575.1 S1 RNA binding domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	531	126	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
32624695	32624695	PRJDB4470_P_NODE_29560_length_424_cov_1.741333_g28419_i0	PRJDB4470	29560	424	1.741333	7.38325192	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	50.1	7.43e-4	NR	XP_636931.1	352472	g28419	i0	52.2	0.325471698113208	46	22	32.5	0	141	4	776	821	XP_636931.1 hypothetical protein DDB_G0288001 [Dictyostelium discoideum AX4]	diamond	138	50.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum

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