metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA631119" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA631119" 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
603109	603109	PRJNA631119_P_NODE_12761_length_349_cov_3.358696_g12643_i0	PRJNA631119	12761	349	3.358696	11.72184904	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	193	1.86e-44	NTclustered	gi\|831791807\|ref\|XM_012904383.1\|	1410327	g12643	i0	79.705	1.43553008595989	271	51	77	4	10	278	404	136	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	501	193	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
3703590	3703590	PRJNA631119_P_NODE_35863_length_245_cov_0.895349_g35745_i0	PRJNA631119	35863	245	0.895349	2.19360505	Dictyostelium	5782	Evosea	other_Eukaryota	226	1.23e-54	NTclustered	gi\|167946\|gb\|M23753.1\|DDIUBIQF	44689	g35745	i0	83.265	378.869387755102	245	41	100	0	1	245	1175	931	D.discoideum ubiquitin mRNA, complete cds, clone DCUB14	blastn	92823	226	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
4430860	4430860	PRJNA631119_P_NODE_14724_length_332_cov_1.335907_g14606_i0	PRJNA631119	14724	332	1.335907	4.43521124	Heterostelium album	2086695	Evosea	other_Eukaryota	196	1.37e-45	NTclustered	gi\|1160559656\|ref\|XM_020577932.1\|	670386	g14606	i0	79.31	72.4457831325301	290	52	86	8	1	286	829	544	Polysphondylium pallidum PN500 isocitrate dehydrogenase (idhC), partial mRNA	blastn	24052	196	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
4430963	4430963	PRJNA631119_P_NODE_32124_length_249_cov_4.738636_g32006_i0	PRJNA631119	32124	249	4.738636	11.79920364	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	182	2.75e-41	NTclustered	gi\|66826022\|ref\|XM_641274.1\|	352472	g32006	i0	83.168	7.16867469879518	202	30	80	3	47	246	200	1	Dictyostelium discoideum AX4 S60 ribosomal protein L36a (rpl36a) mRNA, complete cds	blastn	1785	182	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
4980020	4980020	PRJNA631119_P_NODE_19684_length_298_cov_4.195556_g19566_i0	PRJNA631119	19684	298	4.195556	12.50275688	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	361	4.049999999999999e-95	NTclustered	gi\|426281754\|gb\|JX681130.1\|	289989	g19566	i0	88.814	97.8322147651007	295	31	99	2	5	298	860	567	Didymium squamulosum actin gene, partial cds	blastn	29154	363	0.994490358126722	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium squamulosum
5706740	5706740	PRJNA631119_P_NODE_10865_length_371_cov_1.644295_g10747_i0	PRJNA631119	10865	371	1.644295	6.10033445	Lamproderma aeneum	1115703	Evosea	other_Eukaryota	200	1.19e-46	NTclustered	gi\|2329703422\|gb\|MW240094.1\|	1115703	g10747	i0	76.902	91.0539083557951	368	76	98	8	4	367	658	296	Lamproderma aeneum strain MA-Fungi 90422 elongation factor 1-alpha (EF1a) gene, partial cds	blastn	33781	200	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Stemonitida	Stemonitidae	Lamproderma	Lamproderma aeneum
10807322	10807322	PRJNA631119_P_NODE_10609_length_374_cov_2.401993_g10491_i0	PRJNA631119	10609	374	2.401993	8.98345382	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	58.4	7.65e-4	NTclustered	gi\|470260669\|ref\|XM_004360122.1\|	261658	g10491	i0	80	0.213903743315508	80	14	21	2	31	109	97	175	Cavenderia fasciculata actin binding protein (corA), partial mRNA	blastn	80	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
10807480	10807480	PRJNA631119_P_NODE_37329_length_243_cov_0.905882_g37211_i0	PRJNA631119	37329	243	0.905882	2.20129326	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	261	3.34e-65	NTclustered	gi\|831786029\|ref\|XM_012902522.1\|	1410327	g37211	i0	86.008	99.6913580246914	243	34	100	0	1	243	995	753	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	24225	261	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
10807487	10807487	PRJNA631119_P_NODE_38809_length_241_cov_2.255952_g38691_i0	PRJNA631119	38809	241	2.255952	5.43684432	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	159	1.24e-34	NTclustered	gi\|470268043\|ref\|XM_004362178.1\|	261658	g38691	i0	79.386	8.0207468879668	228	45	94	2	2	228	1	227	Cavenderia fasciculata S60 ribosomal protein L10 (rpl10), partial mRNA	blastn	1933	159	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
12631040	12631040	PRJNA631119_P_NODE_7370_length_431_cov_2.385475_g7252_i0	PRJNA631119	7370	431	2.385475	10.28139725	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.4	8.94e-4	NTclustered	gi\|330791506\|ref\|XM_003283786.1\|	5786	g7252	i0	92.5	1.14849187935035	40	3	9	0	205	244	6327	6288	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_45096), partial mRNA	blastn	495	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
13357378	13357378	PRJNA631119_P_NODE_16811_length_316_cov_1.888889_g16693_i0	PRJNA631119	16811	316	1.888889	5.96888924	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	176	1.68e-39	NTclustered	gi\|330840492\|ref\|XM_003292201.1\|	5786	g16693	i0	79.134	18.5791139240506	254	53	80	0	4	257	536	283	Dictyostelium purpureum Rab GTPase (DICPUDRAFT_50297), mRNA	blastn	5871	176	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
13357405	13357405	PRJNA631119_P_NODE_20551_length_294_cov_1.380090_g20433_i0	PRJNA631119	20551	294	1.38009	4.0574646	Rostrostelium ellipticum	361140	Evosea	other_Eukaryota	300	8.82e-77	NTclustered	gi\|117413669\|emb\|AM168485.1\|	361140	g20433	i0	85.614	65.8095238095238	285	41	97	0	10	294	584	300	Rostrostelium ellipticum partial tuba gene for alpha-tubulin, exon 1, isolate AE2	blastn	19348	300	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Rostrostelium	Rostrostelium ellipticum
13357508	13357508	PRJNA631119_P_NODE_5371_length_491_cov_2.622010_g5253_i0	PRJNA631119	5371	491	2.62201	12.8740691	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	272	3.38e-68	NTclustered	gi\|330842692\|ref\|XM_003293259.1\|	5786	g5253	i0	78.043	14.5580448065173	460	82	91	17	7	455	1561	2012	Dictyostelium purpureum elongation factor 2 (DICPUDRAFT_58424), mRNA	blastn	7148	272	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
15905956	15905956	PRJNA631119_P_NODE_1053_length_990_cov_10.851690_g976_i0	PRJNA631119	1053	990	10.85169	107.431731	Echinostelium arboreum	318077	Evosea	other_Eukaryota	704	0	NTclustered	gi\|61661536\|gb\|AY842032.1\|	318077	g976	i0	81.851	66.0909090909091	843	147	85	6	151	990	1376	537	Echinostelium arboreum strain ATCC 66095 elongation factor 1F-alpha (EF1A) gene, partial cds	blastn	65430	704	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Echinosteliales	Echinosteliidae	Echinostelium	Echinostelium arboreum
15905973	15905973	PRJNA631119_P_NODE_13813_length_340_cov_1.011236_g13695_i0	PRJNA631119	13813	340	1.011236	3.4382024	Heterostelium album	2086695	Evosea	other_Eukaryota	226	1.7899999999999995e-54	NTclustered	gi\|1160552074\|ref\|XM_020571371.1\|	670386	g13695	i0	84.821	12.7970588235294	224	34	66	0	1	224	224	1	Polysphondylium pallidum PN500 hypothetical protein partial mRNA	blastn	4351	226	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
15905985	15905985	PRJNA631119_P_NODE_15793_length_324_cov_1.227092_g15675_i0	PRJNA631119	15793	324	1.227092	3.97577808	Heterostelium album	2086695	Evosea	other_Eukaryota	206	2.21e-48	NTclustered	gi\|1160558840\|ref\|XM_020577524.1\|	670386	g15675	i0	81.746	33.9814814814815	252	40	77	5	29	277	735	487	Polysphondylium pallidum PN500 60S ribosomal protein L8 (rpl8), partial mRNA	blastn	11010	206	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
18455242	18455242	PRJNA631119_P_NODE_18475_length_305_cov_3.594828_g18357_i0	PRJNA631119	18475	305	3.594828	10.9642254	Heterostelium album	2086695	Evosea	other_Eukaryota	327	4.219999999999999e-85	NTclustered	gi\|1160565032\|ref\|XM_020583308.1\|	670386	g18357	i0	86.184	100.2	304	40	99	2	3	305	544	846	Polysphondylium pallidum PN500 actin (act10), partial mRNA	blastn	30561	327	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
18455294	18455294	PRJNA631119_P_NODE_25835_length_270_cov_1.172589_g25717_i0	PRJNA631119	25835	270	1.172589	3.1659903	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	163	1.1e-35	NTclustered	gi\|470247450\|ref\|XM_004357397.1\|	261658	g25717	i0	80.275	0.807407407407407	218	41	80	2	37	253	866	650	Cavenderia fasciculata propionyl-CoA carboxylase (pccB), partial mRNA	blastn	218	163	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
18455322	18455322	PRJNA631119_P_NODE_31035_length_251_cov_0.865169_g30917_i0	PRJNA631119	31035	251	0.865169	2.17157419	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	222	1.64e-53	NTclustered	gi\|330794062\|ref\|XM_003285052.1\|	5786	g30917	i0	85.253	4.7609561752988	217	30	86	2	22	237	901	1116	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_86554), partial mRNA	blastn	1195	222	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
23555822	23555822	PRJNA631119_P_NODE_30559_length_252_cov_1.072626_g30441_i0	PRJNA631119	30559	252	1.072626	2.70301752	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	176	1.3e-39	NTclustered	gi\|831769071\|ref\|XM_012897140.1\|	1410327	g30441	i0	79.757	10.4325396825397	247	46	97	4	1	245	34	278	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	2629	176	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
23555846	23555846	PRJNA631119_P_NODE_34839_length_246_cov_0.890173_g34721_i0	PRJNA631119	34839	246	0.890173	2.18982558	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	56.5	0.002	NTclustered	gi\|831790762\|ref\|XM_012904040.1\|	1410327	g34721	i0	92.5	0.16260162601626	40	1	16	2	164	203	163	126	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	40	56.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum

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