metadata: contig_metadata: 14 rows where bioproject = "PRJEB12366" and tax

14 rows where bioproject = "PRJEB12366" and tax_clade = "Discoba"

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
20816	20816	PRJEB12366_P_NODE_8221_length_272_cov_1.350211_g8031_i0	PRJEB12366	8221	272	1.350211	3.67257392	Neobodo designis	312471	Euglenozoa	other_Eukaryota	503	5.729999999999998e-138	NTclustered	gi\|1172045910\|gb\|KY859412.1\|	312471	g8031	i0	100	96.4816176470588	272	0	100	0	1	272	477	748	Neobodo designis breed flagellate small subunit ribosomal RNA gene, partial sequence	blastn	26243	503	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
2570631	2570631	PRJEB12366_P_NODE_13383_length_198_cov_1.208589_g13193_i0	PRJEB12366	13383	198	1.208589	2.39300622	Bodo saltans	75058	Euglenozoa	other_Eukaryota	119	2.03e-32	NR	CUG83124.1	75058	g13193	i0	84.6	1.96969696969697	65	10	98.5	0	197	3	41	105	CUG83124.1 40S ribosomal protein S13, putative [Bodo saltans]	diamond	390	119	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
10223576	10223576	PRJEB12366_S_NODE_309_length_277_cov_8.421488_g301_i0	PRJEB12366	309	277	8.421488	23.32752176	Allovahlkampfia sp.	1874883	Heterolobosea	other_Eukaryota	501	2.11e-137	NTclustered	gi\|2651357779\|gb\|PP174295.1\|	1874883	g301	i0	99.281	69.4259927797834	278	1	100	1	1	277	2979	3256	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	19231	501	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Allovahlkampfia	Allovahlkampfia sp.
12774429	12774429	PRJEB12366_S_NODE_1571_length_194_cov_2.647799_g1563_i0	PRJEB12366	1571	194	2.647799	5.13673006	Allovahlkampfia sp.	1874883	Heterolobosea	other_Eukaryota	309	9e-80	NTclustered	gi\|2651357779\|gb\|PP174295.1\|	1874883	g1563	i0	96.757	1.94845360824742	185	6	95	0	1	185	1947	2131	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	378	309	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Allovahlkampfia	Allovahlkampfia sp.
14048856	14048856	PRJEB12366_P_NODE_13092_length_201_cov_0.951807_g12902_i0	PRJEB12366	13092	201	0.951807	1.91313207	Acrasis rosea	43695	Heterolobosea	other_Eukaryota	176	9.94e-40	NTclustered	gi\|12083876\|gb\|AF190771.1\|AF190771	43695	g12902	i0	84.066	96.2636815920398	182	29	91	0	19	200	827	1008	Acrasis rosea elongation factor 1 alpha (tef1) gene, partial cds	blastn	19349	176	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis rosea
15322924	15322924	PRJEB12366_P_NODE_14133_length_191_cov_1.307692_g13943_i0	PRJEB12366	14133	191	1.307692	2.49769172	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	52.8	0.016	NTclustered	gi\|2031944425\|emb\|OD958362.1\|	5763	g13943	i0	100	0.43979057591623	28	0	15	0	159	186	2497	2524	Naegleria fowleri Karachi_NF001 strain	blastn	84	52.8	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
15322945	15322945	PRJEB12366_P_NODE_18093_length_162_cov_1.259843_g17903_i0	PRJEB12366	18093	162	1.259843	2.04094566	Neobodo designis	312471	Euglenozoa	other_Eukaryota	294	2.03e-75	NTclustered	gi\|116222274\|gb\|DQ980523.1\|	312471	g17903	i0	99.383	107.135802469136	162	1	100	0	1	162	424	585	Neobodo designis clone ndtub2 beta tubulin gene, partial cds	blastn	17356	294	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
15322959	15322959	PRJEB12366_P_NODE_20433_length_150_cov_0.895652_g20243_i0	PRJEB12366	20433	150	0.895652	1.343478	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	83.6	3.01e-18	NR	KAL0480790.1	1008807	g20243	i0	87.2	0.94	47	6	94	0	143	3	115	161	KAL0480790.1 ribosomal protein L19 [Acrasis kona]	diamond	141	83.6	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
17872378	17872378	PRJEB12366_P_NODE_19255_length_155_cov_1.991667_g19065_i0	PRJEB12366	19255	155	1.991667	3.08708385	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	99.4	1.08e-22	NR	KAJ9464344.1	91374	g19065	i0	92.2	0.987096774193548	51	4	98.7	0	153	1	108	158	KAJ9464344.1 putative succinyl-CoA:3-ketoacid coenzyme A transferase [Diplonema papillatum]	diamond	153	99.4	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
18837459	18837459	PRJEB12366_S_NODE_375_length_260_cov_9.004444_g367_i0	PRJEB12366	375	260	9.004444	23.4115544	Allovahlkampfia	1217108	Heterolobosea	other_Eukaryota	481	2.55e-131	NTclustered	gi\|399764157\|gb\|JQ271668.1\|	1217110	g367	i0	100	25.9692307692308	260	0	100	0	1	260	511	252	Allovahlkampfia sp. PKD 2011a strain 4165 18S ribosomal RNA gene, partial sequence	blastn	6752	481	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Allovahlkampfia	Allovahlkampfia sp. PKD 2011a
19146308	19146308	PRJEB12366_P_NODE_8176_length_273_cov_1.638655_g7986_i0	PRJEB12366	8176	273	1.638655	4.47352815	Allovahlkampfia sp.	1874883	Heterolobosea	other_Eukaryota	449	7.61e-122	NTclustered	gi\|2651357779\|gb\|PP174295.1\|	1874883	g7986	i0	96.35	3.01831501831502	274	9	100	1	1	273	3701	3974	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	824	449	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Allovahlkampfia	Allovahlkampfia sp.
29559199	29559199	PRJEB12366_P_NODE_20130_length_151_cov_1.379310_g19940_i0	PRJEB12366	20130	151	1.37931	2.0827581	Trypanosoma melophagium	715481	Euglenozoa	other_Eukaryota	72.4	1.34e-13	NR	XP_067190936.1	715481	g19940	i0	68	0.993377483443709	50	16	99.3	0	150	1	50	99	XP_067190936.1 Ribosomal protein S3Ae [Trypanosoma melophagium]	diamond	150	72.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma melophagium
31392003	31392003	PRJEB12366_P_NODE_19576_length_154_cov_1.058824_g19386_i0	PRJEB12366	19576	154	1.058824	1.63058896	Bodo saltans	75058	Euglenozoa	other_Eukaryota	101	2.06e-25	NR	CUI15204.1	75058	g19386	i0	90.2	0.993506493506494	51	5	99.4	0	2	154	29	79	CUI15204.1 ADP-ribosylation factor 1, putative [Bodo saltans]	diamond	153	101	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32182772	32182772	PRJEB12366_P_NODE_14298_length_190_cov_0.954839_g14108_i0	PRJEB12366	14298	190	0.954839	1.8141941	Leishmania mexicana MHOM/GT/2	5665	Euglenozoa	other_Eukaryota	45.4	0.00204	NR	XP_003876670.1	929439	g14108	i0	46.6	0.91578947368421	58	29	88.4	2	188	21	1444	1501	XP_003876670.1 putative ABC transporter [Leishmania mexicana MHOM/GT/2001/U1103]	diamond	174	45.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania mexicana

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