metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1166865" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1166865" and tax_phylum = "Discosea"

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
312116	312116	PRJNA1166865_P_NODE_1181_length_1505_cov_20.644553_g1111_i0	PRJNA1166865	1181	1505	20.644553	310.70052265	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	490	2.7599999999999996e-133	NTclustered	gi\|300078498\|gb\|GU001160.1\|	5755	g1111	i0	80.325	54.1707641196013	676	109	73	20	1	660	5136	4469	Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	81527	490	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
312957	312957	PRJNA1166865_P_NODE_44061_length_330_cov_1.665370_g43820_i0	PRJNA1166865	44061	330	1.66537	5.495721	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	274	6.09e-69	NTclustered	gi\|470484553\|ref\|XM_004344028.1\|	1257118	g43820	i0	82.132	38.4151515151515	319	57	97	0	12	330	400	718	Acanthamoeba castellanii str. Neff Sadenosyl-L-homocysteine hydrolase, putative (ACA1_054200), partial mRNA	blastn	12677	274	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
313263	313263	PRJNA1166865_P_NODE_56621_length_294_cov_1.018100_g56380_i0	PRJNA1166865	56621	294	1.0181	2.993214	Vannella sp. ECH30	1215635	Discosea	other_Eukaryota	527	3.719999999999999e-145	NTclustered	gi\|399764220\|gb\|JQ271731.1\|	1215635	g56380	i0	98.98	99.7074829931973	294	3	100	0	1	294	140	433	Vannella sp. ECH30 18S ribosomal RNA gene, partial sequence	blastn	29314	527	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. ECH30
1588040	1588040	PRJNA1166865_P_NODE_62542_length_280_cov_1.144928_g62301_i0	PRJNA1166865	62542	280	1.144928	3.2057984	Ripella tribonemae	2047823	Discosea	other_Eukaryota	427	3.67e-115	NTclustered	gi\|1269228482\|gb\|MF683607.1\|	2047823	g62301	i0	94.056	101.317857142857	286	9	100	8	1	280	1415	1132	Ripella tribonemae clone 22.9.14 18S ribosomal RNA gene, partial sequence	blastn	28369	427	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella tribonemae
1588452	1588452	PRJNA1166865_P_NODE_78642_length_249_cov_1.750000_g78401_i0	PRJNA1166865	78642	249	1.75	4.3575	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	167	7.709999999999999e-37	NTclustered	gi\|470465890\|ref\|XM_004341611.1\|	1257118	g78401	i0	83.908	25.4618473895582	174	28	70	0	76	249	1097	924	Acanthamoeba castellanii str. Neff lysine-tRNA ligase (ACA1_270690), partial mRNA	blastn	6340	167	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
4140000	4140000	PRJNA1166865_P_NODE_53564_length_302_cov_1.323144_g53323_i0	PRJNA1166865	53564	302	1.323144	3.99589488	Mayorella sp. JJP-2003	242541	Discosea	other_Eukaryota	425	1.44e-114	NTclustered	gi\|33946346\|gb\|AY294152.1\|	242541	g53323	i0	92.079	90.158940397351	303	23	100	1	1	302	651	953	Mayorella sp. JJP-2003 actin mRNA, partial cds	blastn	27228	425	1	Eukaryota	Amoebozoa	Discosea		Longamoebia		Mayorella	Mayorella sp. JJP-2003
4867610	4867610	PRJNA1166865_P_NODE_21104_length_467_cov_2.857868_g20863_i0	PRJNA1166865	21104	467	2.857868	13.34624356	Ripella	1217112	Discosea	other_Eukaryota	752	0	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g20863	i0	96.304	99.0856531049251	460	14	99	3	6	465	457	1	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	46273	756	0.994708994708995	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
4867718	4867718	PRJNA1166865_P_NODE_8144_length_739_cov_3.860360_g7933_i0	PRJNA1166865	8144	739	3.86036	28.5280604	Vannella	95228	Discosea	other_Eukaryota	1173	0	NTclustered	gi\|861554667\|gb\|KP719197.1\|	197532	g7933	i0	95.135	74.8051420838972	740	35	100	1	1	739	564	1303	Vannella simplex strain A17WVB small subunit ribosomal RNA gene, partial sequence	blastn	55281	1173	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella simplex
5415773	5415773	PRJNA1166865_P_NODE_35405_length_364_cov_1.587629_g35164_i0	PRJNA1166865	35405	364	1.587629	5.77896956	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	211	5.38e-50	NTclustered	gi\|470442906\|ref\|XM_004339540.1\|	1257118	g35164	i0	79.276	1.91758241758242	304	61	83	2	53	355	315	13	Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA	blastn	698	211	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
6691260	6691260	PRJNA1166865_P_NODE_61206_length_283_cov_1.219048_g60965_i0	PRJNA1166865	61206	283	1.219048	3.44990584	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	254	6.67e-63	NTclustered	gi\|470486807\|ref\|XM_004344593.1\|	1257118	g60965	i0	82.979	0.996466431095406	282	46	99	2	1	281	214	494	Acanthamoeba castellanii str. Neff MC family transporter: phosphate, putative (ACA1_278610), partial mRNA	blastn	282	254	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
9240364	9240364	PRJNA1166865_P_NODE_25528_length_425_cov_5.099432_g25287_i0	PRJNA1166865	25528	425	5.099432	21.672586	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	156	3.03e-33	NTclustered	gi\|470521480\|ref\|XM_004353671.1\|	1257118	g25287	i0	87.407	8.76235294117647	135	17	32	0	215	349	282	148	Acanthamoeba castellanii str. Neff 60S ribosomal protein L27a, putative (ACA1_376690), partial mRNA	blastn	3724	156	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
9241278	9241278	PRJNA1166865_P_NODE_60528_length_284_cov_1.824645_g60287_i0	PRJNA1166865	60528	284	1.824645	5.1819918	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	204	6.839999999999999e-48	NTclustered	gi\|470416742\|ref\|XM_004336868.1\|	1257118	g60287	i0	81.25	12.0176056338028	256	44	89	4	1	254	1494	1241	Acanthamoeba castellanii str. Neff ribonuclease L inhibitor family protein (ACA1_325180), partial mRNA	blastn	3413	204	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
11790927	11790927	PRJNA1166865_P_NODE_21130_length_467_cov_1.784264_g20889_i0	PRJNA1166865	21130	467	1.784264	8.33251288	Stenamoeba aeronauta	2971262	Discosea	other_Eukaryota	549	1.3199999999999997e-151	NTclustered	gi\|2283789716\|gb\|OP179856.1\|	2971262	g20889	i0	95.665	55.7366167023555	346	8	100	4	1	343	885	1226	Stenamoeba aeronauta strain Stenaero small subunit ribosomal RNA gene, partial sequence	blastn	26029	549	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Thecamoebida	Stenamoeba	Stenamoeba aeronauta
11792089	11792089	PRJNA1166865_P_NODE_66590_length_270_cov_2.492386_g66349_i0	PRJNA1166865	66590	270	2.492386	6.7294422	Platyamoeba placida	3454475	Discosea	other_Eukaryota	368	2.16e-97	NTclustered	gi\|33946348\|gb\|AY294153.1\|	197527	g66349	i0	92.278	97.0074074074074	259	20	96	0	12	270	357	99	Platyamoeba placida actin mRNA, partial cds	blastn	26192	368	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Platyamoeba	Platyamoeba placida
13066669	13066669	PRJNA1166865_P_NODE_4991_length_916_cov_1.608541_g4819_i0	PRJNA1166865	4991	916	1.608541	14.73423556	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	597	9.479999999999999e-166	NTclustered	gi\|470420395\|ref\|XM_004337241.1\|	1257118	g4819	i0	79.466	84.92903930131	862	162	93	11	50	905	2520	1668	Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA	blastn	77795	597	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
13067537	13067537	PRJNA1166865_P_NODE_85631_length_246_cov_0.890173_g85390_i0	PRJNA1166865	85631	246	0.890173	2.18982558	Cochliopodium plurinucleolum	1512277	Discosea	other_Eukaryota	403	5.32e-108	NTclustered	gi\|659103930\|gb\|KJ569732.1\|	1512277	g85390	i0	96.341	56.6138211382114	246	8	100	1	1	246	518	762	Cochliopodium plurinucleolum 18S ribosomal RNA gene, partial sequence	blastn	13927	403	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium plurinucleolum
17617374	17617374	PRJNA1166865_P_NODE_70934_length_260_cov_1.647059_g70693_i0	PRJNA1166865	70934	260	1.647059	4.2823534	Vannellidae	95227	Discosea	other_Eukaryota	472	1.53e-128	NTclustered	gi\|399764204\|gb\|JQ271715.1\|	1217115	g70693	i0	99.612	99.4269230769231	258	1	99	0	3	260	1407	1664	Ripella sp. GP2 18S ribosomal RNA gene, partial sequence	blastn	25851	475	0.993684210526316	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. GP2
17617399	17617399	PRJNA1166865_P_NODE_87734_length_245_cov_0.895349_g87493_i0	PRJNA1166865	87734	245	0.895349	2.19360505	Acanthamoeba	5754	Discosea	other_Eukaryota	453	5.1900000000000006e-123	NTclustered	gi\|550826958\|gb\|KF318462.1\|	5755	g87493	i0	100	100.220408163265	245	0	100	0	1	245	2080	1836	Acanthamoeba castellanii strain ATCC 30011 18S ribosomal RNA gene, partial sequence	blastn	24554	453	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
18163766	18163766	PRJNA1166865_P_NODE_14355_length_565_cov_6.339431_g14116_i0	PRJNA1166865	14355	565	6.339431	35.81778515	Platyamoeba placida	3454475	Discosea	other_Eukaryota	739	0	NTclustered	gi\|33946348\|gb\|AY294153.1\|	197527	g14116	i0	90.265	97.4300884955752	565	55	100	0	1	565	482	1046	Platyamoeba placida actin mRNA, partial cds	blastn	55048	739	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Platyamoeba	Platyamoeba placida
18163854	18163854	PRJNA1166865_P_NODE_17755_length_509_cov_1.676606_g17514_i0	PRJNA1166865	17755	509	1.676606	8.53392454	Ripella sp. GP2	1217115	Discosea	other_Eukaryota	811	0	NTclustered	gi\|399764204\|gb\|JQ271715.1\|	1217115	g17514	i0	95.499	100.950884086444	511	18	100	5	1	509	1070	563	Ripella sp. GP2 18S ribosomal RNA gene, partial sequence	blastn	51384	811	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. GP2
21989082	21989082	PRJNA1166865_P_NODE_21678_length_461_cov_3.030928_g21437_i0	PRJNA1166865	21678	461	3.030928	13.97257808	Vannella simplex	197532	Discosea	other_Eukaryota	758	0	NTclustered	gi\|284192604\|gb\|GQ265402.1\|	197532	g21437	i0	96.522	97.3991323210412	460	12	99	2	1	460	343	798	Vannella simplex strain Ladoga Cl 12/2 clone A144.5 18S ribosomal RNA gene, partial sequence	blastn	44901	758	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella simplex
23264749	23264749	PRJNA1166865_P_NODE_30099_length_392_cov_8.272727_g29858_i0	PRJNA1166865	30099	392	8.272727	32.42908984	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	207	7.56e-49	NTclustered	gi\|470442906\|ref\|XM_004339540.1\|	1257118	g29858	i0	79.452	2.1734693877551	292	60	74	0	48	339	21	312	Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA	blastn	852	207	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
24538221	24538221	PRJNA1166865_P_NODE_20260_length_477_cov_1.512376_g20019_i0	PRJNA1166865	20260	477	1.512376	7.21403352	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	305	3.23e-78	NTclustered	gi\|470375091\|ref\|XM_004333111.1\|	1257118	g20019	i0	78.452	78.2159329140461	478	95	99	8	4	477	539	66	Acanthamoeba castellanii str. Neff high molecular weight heat shock protein (ACA1_387860), partial mRNA	blastn	37309	305	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
24538421	24538421	PRJNA1166865_P_NODE_27920_length_407_cov_1.425150_g27679_i0	PRJNA1166865	27920	407	1.42515	5.8003605	Mayorella sp. JJP-2003	242541	Discosea	other_Eukaryota	625	1.8399999999999998e-174	NTclustered	gi\|33946346\|gb\|AY294152.1\|	242541	g27679	i0	94.349	95.8280098280098	407	23	100	0	1	407	941	535	Mayorella sp. JJP-2003 actin mRNA, partial cds	blastn	39002	625	1	Eukaryota	Amoebozoa	Discosea		Longamoebia		Mayorella	Mayorella sp. JJP-2003
25265943	25265943	PRJNA1166865_P_NODE_77840_length_250_cov_0.870056_g77599_i0	PRJNA1166865	77840	250	0.870056	2.17514	Cochliopodium	313557	Discosea	other_Eukaryota	351	1.99e-92	NTclustered	gi\|59876024\|gb\|AY785057.1\|	313998	g77599	i0	98.492	74.436	199	3	80	0	49	247	332	530	Cochliopodium sp. strain Kiel 18S ribosomal RNA gene, partial sequence	blastn	18609	351	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium sp. strain Kiel

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