metadata: contig_metadata: 27 rows where bioproject = "PRJNA641991" and tax

27 rows where bioproject = "PRJNA641991" 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
3168593	3168593	PRJNA641991_P_NODE_2163_length_207_cov_1.607595_g2122_i0	PRJNA641991	2163	207	1.607595	3.32772165	Amoeba proteus	5775	Tubulinea	other_Eukaryota	176	1.03e-39	NTclustered	gi\|33946362\|gb\|AY294160.1\|	5775	g2122	i0	82.828	39.8405797101449	198	32	95	2	2	198	778	974	Amoeba proteus actin mRNA, complete cds	blastn	8247	176	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
3168646	3168646	PRJNA641991_S_NODE_6063_length_221_cov_5.319767_g5944_i0	PRJNA641991	6063	221	5.319767	11.75668507	uncultured Amoebozoa	590481	Root_unresolved	Root_unresolved	409	1.0100000000000001e-109	NTclustered	gi\|365928255\|gb\|JN825705.1\|	590481	g5944	i0	100	82.8597285067873	221	0	100	0	1	221	757	977	Uncultured Amoebozoa clone Alchichica_AQ2b_5E_39 small subunit ribosomal RNA gene, partial sequence	blastn	18312	409	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
4986753	4986753	PRJNA641991_P_NODE_604_length_451_cov_3.761194_g563_i0	PRJNA641991	604	451	3.761194	16.96298494	Vexillifera	218659	Root_unresolved	Root_unresolved	433	1.3399999999999995e-116	NTclustered	gi\|221185864\|gb\|FJ577811.1\|	590481	g563	i0	84.076	33.7472283813747	471	52	100	17	1	451	1767	1300	Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence	blastn	15220	433	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
4986771	4986771	PRJNA641991_S_NODE_9864_length_181_cov_1.227273_g9745_i0	PRJNA641991	9864	181	1.227273	2.22136413	Vexillifera	218659	Root_unresolved	Root_unresolved	335	1.36e-87	NTclustered	gi\|221185864\|gb\|FJ577811.1\|	590481	g9745	i0	100	12.4806629834254	181	0	100	0	1	181	1538	1358	Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence	blastn	2259	335	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
8271054	8271054	PRJNA641991_S_NODE_4007_length_266_cov_1.175115_g3888_i0	PRJNA641991	4007	266	1.175115	3.1258059	Acanthamoeba healyi	65661	Discosea	other_Eukaryota	119	3.8e-30	NR	AAL67857.1	65661	g3888	i0	62.1	2.95488721804511	87	33	98.1	0	261	1	174	260	AAL67857.1 cysteine proteinase [Acanthamoeba healyi]	diamond	786	119	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba healyi
9546359	9546359	PRJNA641991_S_NODE_11108_length_172_cov_1.243902_g10989_i0	PRJNA641991	11108	172	1.243902	2.13951144	Cryptodifflugia operculata	1078836	Tubulinea	other_Eukaryota	200	4.87e-47	NTclustered	gi\|345452564\|gb\|JF694300.1\|	1078836	g10989	i0	87.791	88.1918604651163	172	19	99	2	2	172	796	626	Cryptodifflugia operculata clone 4 actin gene, partial cds	blastn	15169	200	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia operculata
9546370	9546370	PRJNA641991_S_NODE_2228_length_351_cov_2.927152_g2109_i0	PRJNA641991	2228	351	2.927152	10.27430352	uncultured Amoebozoa	590481	Root_unresolved	Root_unresolved	401	2.86e-107	NTclustered	gi\|221185864\|gb\|FJ577811.1\|	590481	g2109	i0	87.193	59.1481481481481	367	29	100	12	1	351	1194	1558	Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence	blastn	20761	401	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
10822020	10822020	PRJNA641991_S_NODE_6569_length_214_cov_4.460606_g6450_i0	PRJNA641991	6569	214	4.460606	9.54569684	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	154	5.02e-33	NTclustered	gi\|330843266\|ref\|XM_003293532.1\|	5786	g6450	i0	87.407	10.2803738317757	135	16	63	1	80	214	165	298	Dictyostelium purpureum ADP-ribosylation factor 1 (arfA), mRNA	blastn	2200	154	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
12097165	12097165	PRJNA641991_S_NODE_11670_length_168_cov_1.957983_g11551_i0	PRJNA641991	11670	168	1.957983	3.28941144	Cochliopodium spiniferum	313558	Discosea	other_Eukaryota	150	4.86e-32	NTclustered	gi\|330902897\|gb\|JF298273.1\|	313558	g11551	i0	83.133	20.3809523809524	166	26	98	2	2	166	199	363	Cochliopodium spiniferum clone 5102 actin gene, partial cds	blastn	3424	150	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium spiniferum
14646719	14646719	PRJNA641991_S_NODE_5852_length_225_cov_1.392045_g5733_i0	PRJNA641991	5852	225	1.392045	3.13210125	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	220	5.18e-53	NTclustered	gi\|66821326\|ref\|XM_639065.1\|	352472	g5733	i0	84.375	98.4133333333333	224	35	99	0	1	224	806	583	Dictyostelium discoideum AX4 hypothetical protein (act13) mRNA, complete cds	blastn	22143	220	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
16461204	16461204	PRJNA641991_S_NODE_5913_length_224_cov_1.217143_g5794_i0	PRJNA641991	5913	224	1.217143	2.72640032	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	311	2.97e-80	NTclustered	gi\|399764267\|gb\|JQ271778.1\|	1215988	g5794	i0	98.851	35.6205357142857	174	2	78	0	1	174	1751	1924	Tubulinea group 02 sp. HF1KJ 18S ribosomal RNA gene, partial sequence	blastn	7979	311	1	Eukaryota	Amoebozoa	Tubulinea					Tubulinea group 02 sp. HF1KJ
21020196	21020196	PRJNA641991_S_NODE_6757_length_212_cov_0.938650_g6638_i0	PRJNA641991	6757	212	0.93865	1.989938	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	101	2.87e-24	NR	XP_003294400.1	5786	g6638	i0	68.6	43.5849056603774	70	22	99.1	0	211	2	133	202	XP_003294400.1 uncharacterized protein DICPUDRAFT_51485 [Dictyostelium purpureum]	diamond	9240	101	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
23570499	23570499	PRJNA641991_S_NODE_339_length_855_cov_20.884615_g266_i0	PRJNA641991	339	855	20.884615	178.56345825	uncultured Amoebozoa	590481	Root_unresolved	Root_unresolved	874	0	NTclustered	gi\|221185864\|gb\|FJ577811.1\|	590481	g266	i0	88.472	28.3239766081871	746	57	95	20	1	719	268	1011	Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence	blastn	24217	874	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
24110285	24110285	PRJNA641991_S_NODE_4679_length_247_cov_7.207071_g4560_i0	PRJNA641991	4679	247	7.207071	17.80146537	Vexillifera	218659	Root_unresolved	Root_unresolved	265	2.63e-66	NTclustered	gi\|221185864\|gb\|FJ577811.1\|	590481	g4560	i0	86.056	42.6113360323887	251	30	100	5	1	247	1785	1536	Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence	blastn	10525	265	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
27144030	27144030	PRJNA641991_S_NODE_13002_length_165_cov_0.879310_g12883_i0	PRJNA641991	13002	165	0.87931	1.4508615	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	83.2	2.33e-17	NR	XP_003287614.1	5786	g12883	i0	85.5	1	55	8	100	0	165	1	186	240	XP_003287614.1 calcium-regulated actin-bundling protein [Dictyostelium purpureum]	diamond	165	83.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
27808001	27808001	PRJNA641991_S_NODE_6124_length_221_cov_0.872093_g6005_i0	PRJNA641991	6124	221	0.872093	1.92732553	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	53.9	3.09e-6	NR	XP_004341646.1	1257118	g6005	i0	52.1	0.65158371040724	48	20	61.1	1	219	85	335	382	XP_004341646.1 papain family cysteine protease containing protein [Acanthamoeba castellanii str. Neff]	diamond	144	53.9	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27965584	27965584	PRJNA641991_S_NODE_14405_length_162_cov_0.902655_g14286_i0	PRJNA641991	14405	162	0.902655	1.4623011	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	83.2	2.84e-17	NR	XP_004341120.1	1257118	g14286	i0	71.7	1.96296296296296	53	15	98.1	0	1	159	105	157	XP_004341120.1 spliceosomal protein, putative [Acanthamoeba castellanii str. Neff]	diamond	318	83.2	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28597263	28597263	PRJNA641991_S_NODE_14727_length_161_cov_0.910714_g14608_i0	PRJNA641991	14727	161	0.910714	1.46624954	Copromyxa protea	931554	Tubulinea	other_Eukaryota	97.1	6.75e-22	NR	BAN33737.1	931554	g14608	i0	83	5.92546583850932	53	9	98.8	0	159	1	277	329	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	954	97.1	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
28786388	28786388	PRJNA641991_S_NODE_9227_length_186_cov_1.116788_g9108_i0	PRJNA641991	9227	186	1.116788	2.07722568	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	69.7	5.28e-12	NR	XP_004341947.1	1257118	g9108	i0	61.7	2.93548387096774	60	22	96.8	1	182	3	555	613	XP_004341947.1 gelation factor, putative [Acanthamoeba castellanii str. Neff]	diamond	546	69.7	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29070939	29070939	PRJNA641991_S_NODE_11928_length_167_cov_1.296610_g11809_i0	PRJNA641991	11928	167	1.29661	2.1653387	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	74.3	8.1e-15	NR	KYR01920.1	361077	g11809	i0	82.6	0.826347305389222	46	8	82.6	0	5	142	96	141	KYR01920.1 S60 ribosomal protein L17 [Tieghemostelium lacteum]	diamond	138	74.3	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
29714151	29714151	PRJNA641991_S_NODE_13730_length_163_cov_0.894737_g13611_i0	PRJNA641991	13730	163	0.894737	1.45842131	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	97.4	4.1800000000000003e-22	NR	XP_004354490.1	261658	g13611	i0	75.9	5.98159509202454	54	13	99.4	0	1	162	288	341	XP_004354490.1 S-adenosyl-L-homocysteine hydrolase [Cavenderia fasciculata]	diamond	975	98.2	0.991853360488798	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
29935729	29935729	PRJNA641991_S_NODE_10251_length_178_cov_1.186047_g10132_i0	PRJNA641991	10251	178	1.186047	2.11116366	Eumycetozoa	142796	Evosea	other_Eukaryota	85.1	7.94e-19	NR	KYR02571.1	361077	g10132	i0	74.6	3.97752808988764	59	15	99.4	0	178	2	51	109	KYR02571.1 ribosomal protein [Tieghemostelium lacteum]	diamond	708	85.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
30744790	30744790	PRJNA641991_S_NODE_5554_length_230_cov_1.408840_g5435_i0	PRJNA641991	5554	230	1.40884	3.240332	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	89	3.64e-20	NR	XP_004334891.1	1257118	g5435	i0	58.5	0.847826086956522	65	27	84.8	0	1	195	107	171	XP_004334891.1 ribosomal protein L11, domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	195	89	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30788659	30788659	PRJNA641991_S_NODE_13354_length_164_cov_0.886957_g13235_i0	PRJNA641991	13354	164	0.886957	1.45460948	Acytosteliaceae	2058183	Evosea	other_Eukaryota	45.8	0.00104	NR	XP_020428908.1	670386	g13235	i0	62.5	1.55487804878049	32	10	54.9	1	164	75	359	390	XP_020428908.1 putative protein tyrosine phosphatase [Heterostelium album PN500]	diamond	255	46.2	0.991341991341991	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
30851798	30851798	PRJNA641991_S_NODE_8234_length_195_cov_1.047945_g8115_i0	PRJNA641991	8234	195	1.047945	2.04349275	Eumycetozoa	142796	Evosea	other_Eukaryota	60.1	1.49e-8	NR	XP_003284481.1	5786	g8115	i0	50.8	5.75384615384615	63	28	96.9	2	194	6	550	609	XP_003284481.1 uncharacterized protein DICPUDRAFT_91322 [Dictyostelium purpureum]	diamond	1122	60.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
31155121	31155121	PRJNA641991_P_NODE_1775_length_232_cov_1.038251_g1734_i0	PRJNA641991	1775	232	1.038251	2.40874232	Copromyxa protea	931554	Tubulinea	other_Eukaryota	125	8.87e-32	NR	BAN33737.1	931554	g1734	i0	72.7	1.97844827586207	77	21	99.6	0	1	231	296	372	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	459	125	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
31471913	31471913	PRJNA641991_S_NODE_14876_length_161_cov_0.910714_g14757_i0	PRJNA641991	14876	161	0.910714	1.46624954	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	65.5	3.36e-11	NR	XP_004341316.1	1257118	g14757	i0	59.6	0.875776397515528	47	19	87.6	0	19	159	112	158	XP_004341316.1 proteasome subunit beta type2, putative [Acanthamoeba castellanii str. Neff]	diamond	141	65.5	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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