metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA753704" 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
2007205	2007205	PRJNA753704_P_NODE_6242_length_460_cov_4.387597_g5881_i0	PRJNA753704	6242	460	4.387597	20.1829462	Paramoeba branchiphila	308475	Discosea	other_Eukaryota	305	3.1e-78	NTclustered	gi\|226347442\|gb\|FJ807261.1\|	308475	g5881	i0	78.901	72.795652173913	455	90	98	6	9	460	515	966	Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds	blastn	33486	305	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba branchiphila
2007233	2007233	PRJNA753704_P_NODE_9262_length_385_cov_1.839744_g8901_i0	PRJNA753704	9262	385	1.839744	7.0830144	Paramoeba pemaquidensis	180228	Discosea	other_Eukaryota	121	9.93e-23	NTclustered	gi\|1079488025\|ref\|NC_031417.1\|	180228	g8901	i0	74.052	15.587012987013	343	68	87	18	52	385	32816	32486	Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome	blastn	6001	121	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba pemaquidensis
3282330	3282330	PRJNA753704_P_NODE_18963_length_278_cov_2.682927_g18602_i0	PRJNA753704	18963	278	2.682927	7.45853706	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	193	1.45e-44	NTclustered	gi\|831791807\|ref\|XM_012904383.1\|	1410327	g18602	i0	80	1.37769784172662	265	49	95	4	16	278	136	398	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	383	193	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
3282520	3282520	PRJNA753704_P_NODE_7803_length_416_cov_6.212828_g7442_i0	PRJNA753704	7803	416	6.212828	25.84536448	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	625	1.8799999999999998e-174	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g7442	i0	93.75	1	416	26	100	0	1	416	199	614	Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	416	625	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
5834615	5834615	PRJNA753704_P_NODE_20005_length_271_cov_81.196970_g19644_i0	PRJNA753704	20005	271	81.19697	220.0437887	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	307	4.8e-79	NTclustered	gi\|292559443\|ref\|NC_013986.1\|	5778	g19644	i0	94.472	46.1143911439114	199	11	73	0	1	199	27236	27038	Hartmannella vermiformis mitochondrion, complete genome	blastn	12497	307	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
13484819	13484819	PRJNA753704_P_NODE_19611_length_274_cov_1.995025_g19250_i0	PRJNA753704	19611	274	1.995025	5.4663685	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	204	6.569999999999999e-48	NTclustered	gi\|909719647\|gb\|KT185627.1\|	5778	g19250	i0	80.292	1	274	51	99	3	2	274	24880	25151	Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome	blastn	274	204	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
13485002	13485002	PRJNA753704_P_NODE_9451_length_381_cov_12.211039_g9090_i0	PRJNA753704	9451	381	12.211039	46.52405859	uncultured Amoebozoa	590481	Root_unresolved	Root_unresolved	673	0	NTclustered	gi\|365928255\|gb\|JN825705.1\|	590481	g9090	i0	98.688	60.3779527559055	381	2	100	3	1	381	665	1042	Uncultured Amoebozoa clone Alchichica_AQ2b_5E_39 small subunit ribosomal RNA gene, partial sequence	blastn	23004	673	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
16033780	16033780	PRJNA753704_P_NODE_3033_length_638_cov_2.596460_g2680_i0	PRJNA753704	3033	638	2.59646	16.5654148	Acanthamoeba polyphaga	5757	Discosea	other_Eukaryota	182	7.75e-41	NTclustered	gi\|28194599\|gb\|AF479543.1\|	5757	g2680	i0	73.045	16.1520376175549	601	128	91	28	56	638	235	819	Acanthamoeba polyphaga strain Sawyer CCAP 1501/3C 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product	blastn	10305	182	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba polyphaga
16033835	16033835	PRJNA753704_P_NODE_7113_length_435_cov_1.781768_g6752_i0	PRJNA753704	7113	435	1.781768	7.7506908	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	599	1.1999999999999995e-166	NTclustered	gi\|909719647\|gb\|KT185627.1\|	5778	g6752	i0	96.919	65.216091954023	357	11	82	0	1	357	20630	20274	Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome	blastn	28369	599	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
17309096	17309096	PRJNA753704_P_NODE_14654_length_312_cov_6.979079_g14293_i0	PRJNA753704	14654	312	6.979079	21.774726480000002	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	549	8.489999999999997e-152	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g14293	i0	98.397	26.5865384615385	312	5	100	0	1	312	6746	7057	Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	8295	549	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
17309106	17309106	PRJNA753704_P_NODE_15314_length_306_cov_4.330472_g14953_i0	PRJNA753704	15314	306	4.330472	13.25124432	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	429	1.13e-115	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g14953	i0	91.883	1.00653594771242	308	23	100	2	1	306	935	628	Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	308	429	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
17309158	17309158	PRJNA753704_P_NODE_20534_length_268_cov_7.579487_g20173_i0	PRJNA753704	20534	268	7.579487	20.31302516	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	457	4.45e-124	NTclustered	gi\|909719647\|gb\|KT185627.1\|	5778	g20173	i0	97.388	167.481343283582	268	7	100	0	1	268	28352	28085	Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome	blastn	44885	457	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
17309326	17309326	PRJNA753704_P_NODE_6934_length_439_cov_7.765027_g6573_i0	PRJNA753704	6934	439	7.765027	34.08846853	Paramoeba aparasomata	2583407	Discosea	other_Eukaryota	91.6	8.99e-14	NTclustered	gi\|1767098935\|gb\|MK518072.1\|	2583407	g6573	i0	73.065	10.9703872437358	323	61	71	16	1	312	14255	14562	Paramoeba aparasomata mitochondrion, complete genome	blastn	4816	91.6	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba aparasomata
18583048	18583048	PRJNA753704_P_NODE_6655_length_448_cov_1.288000_g6294_i0	PRJNA753704	6655	448	1.288	5.77024	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	390	8.089999999999999e-104	NTclustered	gi\|909719647\|gb\|KT185627.1\|	5778	g6294	i0	82.405	9.48883928571429	449	77	100	2	1	448	1184	1631	Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome	blastn	4251	390	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
21133647	21133647	PRJNA753704_P_NODE_25897_length_247_cov_2.724138_g25536_i0	PRJNA753704	25897	247	2.724138	6.72862086	uncultured Amoebozoa	590481	Root_unresolved	Root_unresolved	407	4.14e-109	NTclustered	gi\|365928255\|gb\|JN825705.1\|	590481	g25536	i0	96.371	58.502024291498	248	7	100	2	1	247	93	339	Uncultured Amoebozoa clone Alchichica_AQ2b_5E_39 small subunit ribosomal RNA gene, partial sequence	blastn	14450	407	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
21604197	21604197	PRJNA753704_P_NODE_2077_length_754_cov_12.362702_g1745_i0	PRJNA753704	2077	754	12.362702	93.21477308	Vermamoeba	1260114	Tubulinea	other_Eukaryota	1343	0	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g1745	i0	98.806	98.0477453580902	754	9	100	0	1	754	4885	5638	Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	73928	1343	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
22408445	22408445	PRJNA753704_P_NODE_21138_length_265_cov_1.625000_g20777_i0	PRJNA753704	21138	265	1.625	4.30625	Amoebozoa sp. Tmp4	688093	Root_unresolved	Root_unresolved	366	7.62e-97	NTclustered	gi\|429836225\|emb\|HE802057.1\|	688093	g20777	i0	91.954	98.5924528301887	261	21	98	0	5	265	894	634	Amoebozoa sp. Tmp4 partial actin gene for actin, isolate Tmp4	blastn	26127	366	1	Eukaryota	Amoebozoa						Amoebozoa sp. Tmp4
25428758	25428758	PRJNA753704_P_NODE_7480_length_425_cov_4.173295_g7119_i0	PRJNA753704	7480	425	4.173295	17.73650375	Eumycetozoa	142796	Evosea	other_Eukaryota	209	2.3e-49	NTclustered	gi\|556912445\|gb\|KF662130.1\|	142829	g7119	i0	85.93	45.5505882352941	199	24	46	4	16	212	533	337	Cavenderia aureostipes isolate KP3 ATPase1 (atp1) gene, partial cds; mitochondrial	blastn	19359	209	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia aureostipes

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