metadata: contig_metadata: 10 rows where bioproject = "PRJEB81171", tax_clade = "Discoba" and tax

10 rows where bioproject = "PRJEB81171", tax_clade = "Discoba" and tax_phylum = "Heterolobosea"

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_family	tax_genus	tax_species
139326	139326	PRJEB81171_P_NODE_281_length_1185_cov_6.553058_g206_i0	PRJEB81171	281	1185	6.553058	77.6537373	Heterolobosea sp. HGG1	1237086	Heterolobosea	other_Eukaryota	1624	0	NTclustered	gi\|407750695\|gb\|JX441981.1\|	1237086	g206	i0	91.443	44.1113924050633	1192	88	100	13	1	1185	1199	15	Heterolobosea sp. HGG1 18S ribosomal RNA gene, partial sequence	blastn	52272	1624	1	Eukaryota	Discoba	Heterolobosea			Heterolobosea sp. HGG1
6517529	6517529	PRJEB81171_P_NODE_266_length_1218_cov_4.388646_g194_i0	PRJEB81171	266	1218	4.388646	53.45370828	Allovahlkampfia sp.	1874883	Heterolobosea	other_Eukaryota	274	2.4399999999999993e-68	NTclustered	gi\|2651357779\|gb\|PP174295.1\|	1874883	g194	i0	77.301	15.5894909688013	489	95	47	11	1	479	3207	2725	Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	18988	274	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Allovahlkampfia	Allovahlkampfia sp.
12892807	12892807	PRJEB81171_P_NODE_1311_length_572_cov_3.396794_g1189_i0	PRJEB81171	1311	572	3.396794	19.42966168	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	353	1.3799999999999997e-92	NTclustered	gi\|2618963742\|gb\|OR769034.1\|	5762	g1189	i0	78.209	73.4073426573427	592	101	100	20	1	572	4769	5352	Naegleria gruberi strain NEG-M rDNA-containing extrachromosomal element genomic sequence; and 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	41989	353	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
17990881	17990881	PRJEB81171_P_NODE_1615_length_520_cov_1.040268_g1492_i0	PRJEB81171	1615	520	1.040268	5.4093936	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	191	9.789999999999996e-55	NR	XP_044566001.1	5763	g1492	i0	57.8	3.99230769230769	173	73	99.8	0	1	519	73	245	XP_044566001.1 uncharacterized protein FDP41_012548 [Naegleria fowleri]	diamond	2076	192	0.994791666666667	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
20123159	20123159	PRJEB81171_P_NODE_1616_length_519_cov_11.026906_g1493_i0	PRJEB81171	1616	519	11.026906	57.22964214	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	813	0	NTclustered	gi\|407750695\|gb\|JX441981.1\|	1237086	g1493	i0	95.155	41.0867052023121	516	24	99	1	4	519	1722	1208	Heterolobosea sp. HGG1 18S ribosomal RNA gene, partial sequence	blastn	21324	813	1	Eukaryota	Discoba	Heterolobosea			Heterolobosea sp. HGG1
28069286	28069286	PRJEB81171_P_NODE_8285_length_250_cov_0.881356_g8158_i0	PRJEB81171	8285	250	0.881356	2.20339	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	121	7.46e-30	NR	XP_044548617.1	51637	g8158	i0	65.1	5.976	83	29	99.6	0	2	250	866	948	XP_044548617.1 uncharacterized protein C9374_004905 [Naegleria lovaniensis]	diamond	1494	121	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria lovaniensis
29654867	29654867	PRJEB81171_P_NODE_7110_length_261_cov_1.569149_g6983_i0	PRJEB81171	7110	261	1.569149	4.09547889	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	59.3	6.55e-8	NR	XP_044560734.1	5763	g6983	i0	36	3.82758620689655	89	53	97.7	3	6	260	405	493	XP_044560734.1 uncharacterized protein FDP41_004697 [Naegleria fowleri]	diamond	999	59.3	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
30697656	30697656	PRJEB81171_P_NODE_6794_length_266_cov_1.590674_g6667_i0	PRJEB81171	6794	266	1.590674	4.23119284	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	58.2	1.87e-7	NR	CAG4716594.1	5763	g6667	i0	38.6	0.992481203007519	88	52	97	1	8	265	589	676	CAG4716594.1 unnamed protein product [Naegleria fowleri]	diamond	264	58.2	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
31290746	31290746	PRJEB81171_P_NODE_8095_length_251_cov_0.876404_g7968_i0	PRJEB81171	8095	251	0.876404	2.19977404	Naegleria	5761	Heterolobosea	other_Eukaryota	62.8	1.72e-9	NR	XP_002671304.1	5762	g7968	i0	38.4	4.24302788844621	73	45	87.3	0	29	247	112	184	XP_002671304.1 uncharacterized protein NAEGRDRAFT_73614 [Naegleria gruberi]	diamond	1065	63.2	0.993670886075949	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
32752573	32752573	PRJEB81171_P_NODE_2800_length_395_cov_0.968944_g2673_i0	PRJEB81171	2800	395	0.968944	3.8273288	Naegleria lovaniensis	51637	Heterolobosea	other_Eukaryota	105	4.01e-24	NR	XP_044548436.1	51637	g2673	i0	44.6	2.76455696202532	121	59	91.9	2	20	382	199	311	XP_044548436.1 uncharacterized protein C9374_005337 [Naegleria lovaniensis]	diamond	1092	105	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria lovaniensis

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