metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA975724" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA975724" 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
3497203	3497203	PRJNA975724_S_NODE_5803_length_506_cov_12.413395_g5624_i0	PRJNA975724	5803	506	12.413395	62.8117787	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	56.5	0.004	NTclustered	gi\|470237499\|ref\|XM_004350656.1\|	261658	g5624	i0	88.889	0.0889328063241107	45	5	9	0	431	475	1936	1892	Cavenderia fasciculata uncharacterized protein (DD3-3), partial mRNA	blastn	45	56.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
3818754	3818754	PRJNA975724_S_NODE_22823_length_374_cov_1.720930_g22642_i0	PRJNA975724	22823	374	1.72093	6.4362782	Dictyostelium	5782	Evosea	other_Eukaryota	215	4.29e-51	NTclustered	gi\|290056\|gb\|L16579.1\|DDITATBPB	44689	g22642	i0	78.593	12.0374331550802	327	69	87	1	24	349	1165	839	Dictyostelium discoideum HIV1 TAT-binding protein homologue (TBP1O) mRNA, 3' end	blastn	4502	215	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
6048547	6048547	PRJNA975724_S_NODE_10205_length_448_cov_7.034667_g10024_i0	PRJNA975724	10205	448	7.034667	31.51530816	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	110	2.54e-19	NTclustered	gi\|470414640\|ref\|XM_004336659.1\|	1257118	g10024	i0	80.405	0.772321428571429	148	25	33	4	302	447	1511	1366	Acanthamoeba castellanii str. Neff AcetylCoA carboxylase, carboxyltransferase component, putative (ACA1_022220), partial mRNA	blastn	346	110	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
7323371	7323371	PRJNA975724_S_NODE_11866_length_434_cov_10.365651_g11685_i0	PRJNA975724	11866	434	10.365651	44.98692534	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	148	5.2e-31	NTclustered	gi\|470423488\|ref\|XM_004337555.1\|	1257118	g11685	i0	79.263	45.46313364055301	217	41	50	4	59	273	367	581	Acanthamoeba castellanii str. Neff ribosomal protein L23, putative (ACA1_164710), partial mRNA	blastn	19731	148	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
9875501	9875501	PRJNA975724_S_NODE_8648_length_464_cov_17.803069_g8467_i0	PRJNA975724	8648	464	17.803069	82.60624016	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	159	2.58e-34	NTclustered	gi\|831768889\|ref\|XM_012897087.1\|	1410327	g8467	i0	77.256	14.9461206896552	277	60	59	3	186	461	991	717	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	6935	159	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
13699333	13699333	PRJNA975724_S_NODE_22431_length_375_cov_4.788079_g22250_i0	PRJNA975724	22431	375	4.788079	17.95529625	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	65.8	4.58e-6	NTclustered	gi\|66806656\|ref\|XM_631959.1\|	352472	g22250	i0	95.122	0.184	41	2	11	0	311	351	341	301	Dictyostelium discoideum AX4 elongation factor 2 (cinC) mRNA, complete cds	blastn	69	65.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
14020663	14020663	PRJNA975724_S_NODE_5031_length_522_cov_1.603563_g4852_i0	PRJNA975724	5031	522	1.603563	8.37059886	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	571	3.1799999999999995e-158	NTclustered	gi\|161207\|gb\|M21500.1\|SLMACT35	5791	g4852	i0	88.699	90.4808429118774	469	51	90	2	55	522	1163	696	P.polycephalum actin (Ppa35) mRNA, complete cds	blastn	47231	571	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
14973435	14973435	PRJNA975724_S_NODE_1752_length_690_cov_4.753647_g1590_i0	PRJNA975724	1752	690	4.753647	32.8001643	Cochliopodium minus	313997	Discosea	other_Eukaryota	970	0	NTclustered	gi\|330902862\|gb\|JF298257.1\|	313997	g1590	i0	94.662	47.5304347826087	637	15	91	14	62	690	4	629	Cochliopodium minus 18S ribosomal RNA gene, partial sequence	blastn	32796	970	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium minus
14973716	14973716	PRJNA975724_S_NODE_28772_length_352_cov_1.856631_g28591_i0	PRJNA975724	28772	352	1.856631	6.53534112	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	185	3.14e-42	NTclustered	gi\|292559443\|ref\|NC_013986.1\|	5778	g28591	i0	78.853	37.7045454545455	279	55	79	3	1	277	27458	27734	Hartmannella vermiformis mitochondrion, complete genome	blastn	13272	185	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
16250124	16250124	PRJNA975724_S_NODE_82153_length_248_cov_1.148571_g81972_i0	PRJNA975724	82153	248	1.148571	2.84845608	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	137	6.019999999999999e-28	NTclustered	gi\|470375091\|ref\|XM_004333111.1\|	1257118	g81972	i0	82.716	45.0685483870968	162	21	65	4	76	235	229	73	Acanthamoeba castellanii str. Neff high molecular weight heat shock protein (ACA1_387860), partial mRNA	blastn	11177	137	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
17523502	17523502	PRJNA975724_S_NODE_15754_length_408_cov_5.453731_g15573_i0	PRJNA975724	15754	408	5.453731	22.25122248	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	126	2.2799999999999998e-24	NTclustered	gi\|470494240\|ref\|XM_004346562.1\|	1257118	g15573	i0	77.778	3.60294117647059	216	40	52	8	163	374	1110	899	Acanthamoeba castellanii str. Neff S(hydroxymethyl)glutathione dehydrogenase/class III alcohol dehydrogenase (ACA1_230530), partial mRNA	blastn	1470	126	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
21349376	21349376	PRJNA975724_S_NODE_8477_length_466_cov_12.050891_g8296_i0	PRJNA975724	8477	466	12.050891	56.15715206	Vannellidae sp.	2491907	Discosea	other_Eukaryota	224	9.069999999999999e-54	NTclustered	gi\|1523769313\|gb\|MH535955.1\|	2491907	g8296	i0	80.583	35.7124463519313	309	44	66	12	90	395	700	405	Vannellidae sp. strain 147SVA_C2 18S ribosomal RNA gene, partial sequence; mitochondrial	blastn	16642	224	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae		Vannellidae sp.
21349631	21349631	PRJNA975724_S_NODE_94477_length_208_cov_4.044444_g94296_i0	PRJNA975724	94477	208	4.044444	8.41244352	Phalansterium sp. PJK-2012	1267188	Evosea	other_Eukaryota	62.1	3.03e-5	NTclustered	gi\|429125732\|gb\|KC121006.1\|	1267188	g94296	i0	100	0.158653846153846	33	0	16	0	123	155	414	446	Phalansterium sp. PJK-2012 mitochondrion, complete genome	blastn	33	62.1	1	Eukaryota	Amoebozoa	Evosea	Variosea			Phalansterium	Phalansterium sp. PJK-2012
23900072	23900072	PRJNA975724_S_NODE_959_length_814_cov_3.840756_g820_i0	PRJNA975724	959	814	3.840756	31.26375384	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	514	8.679999999999999e-141	NTclustered	gi\|470375091\|ref\|XM_004333111.1\|	1257118	g820	i0	80.689	84.3636363636364	668	123	82	6	9	673	684	20	Acanthamoeba castellanii str. Neff high molecular weight heat shock protein (ACA1_387860), partial mRNA	blastn	68672	514	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);;