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

14 rows where bioproject = "PRJNA1086823" 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
193640	193640	PRJNA1086823_P_NODE_11341_length_259_cov_1.634409_g11224_i0	PRJNA1086823	11341	259	1.634409	4.23311931	Amoebozoa sp.	1892891	Root_unresolved	Root_unresolved	259	1.29e-64	NTclustered	gi\|2651357787\|gb\|PP174302.1\|	1892891	g11224	i0	90.452	40.6525096525097	199	15	77	3	16	214	3954	4148	Amoebozoa sp. isolate 2M 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	10529	259	1	Eukaryota	Amoebozoa						Amoebozoa sp.
193687	193687	PRJNA1086823_P_NODE_13561_length_251_cov_0.876404_g13444_i0	PRJNA1086823	13561	251	0.876404	2.19977404	Ripella platypodia	2047821	Discosea	other_Eukaryota	429	8.99e-116	NTclustered	gi\|1269228378\|gb\|MF683503.1\|	2047821	g13444	i0	97.61	100.792828685259	251	4	100	1	1	251	1510	1262	Ripella platypodia clone 26.10.41 18S ribosomal RNA gene, partial sequence	blastn	25299	429	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella platypodia
193863	193863	PRJNA1086823_P_NODE_4981_length_357_cov_1.070423_g4864_i0	PRJNA1086823	4981	357	1.070423	3.82141011	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	174	3.34e-50	NR	PRP84143.1	1890364	g4864	i0	75.2	20.2100840336134	109	27	91.6	0	30	356	280	388	PRP84143.1 hypothetical protein PROFUN_04134 [Planoprotostelium fungivorum]	diamond	7215	174	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
1468576	1468576	PRJNA1086823_P_NODE_8462_length_288_cov_1.255814_g8345_i0	PRJNA1086823	8462	288	1.255814	3.61674432	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	276	1.45e-69	NTclustered	gi\|300078498\|gb\|GU001160.1\|	5755	g8345	i0	85.764	21.1388888888889	288	10	100	16	1	288	5438	5694	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	6088	276	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
15496316	15496316	PRJNA1086823_P_NODE_12573_length_252_cov_1.664804_g12456_i0	PRJNA1086823	12573	252	1.664804	4.19530608	Vexillifera bacillipedes	1105345	Discosea	other_Eukaryota	466	6.89e-127	NTclustered	gi\|399764261\|gb\|JQ271772.1\|	1105345	g12456	i0	100	73.9285714285714	252	0	100	0	1	252	303	554	Vexillifera bacillipedes strain 6HZM 18S ribosomal RNA gene, partial sequence	blastn	18630	466	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Vexilliferidae	Vexillifera	Vexillifera bacillipedes
15496604	15496604	PRJNA1086823_P_NODE_8733_length_285_cov_1.424528_g8616_i0	PRJNA1086823	8733	285	1.424528	4.0599048	Vannella septentrionalis	197531	Discosea	other_Eukaryota	490	4.71e-134	NTclustered	gi\|300078499\|gb\|GU001161.1\|	197531	g8616	i0	97.88	80.2456140350877	283	6	99	0	1	283	947	1229	Vannella septentrionalis 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	22870	490	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella septentrionalis
18045460	18045460	PRJNA1086823_P_NODE_15655_length_247_cov_1.511494_g15538_i0	PRJNA1086823	15655	247	1.511494	3.73339018	Lobosea sp. Borok	297386	Tubulinea	other_Eukaryota	433	6.82e-117	NTclustered	gi\|54306228\|gb\|AY626163.1\|	297386	g15538	i0	98.381	100.611336032389	247	3	100	1	1	247	973	728	Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence	blastn	24851	433	1	Eukaryota	Amoebozoa	Tubulinea					Lobosea sp. Borok
23146096	23146096	PRJNA1086823_P_NODE_6239_length_325_cov_3.043651_g6122_i0	PRJNA1086823	6239	325	3.043651	9.89186575	uncultured Amoebozoa	590481	Root_unresolved	Root_unresolved	579	1.1299999999999997e-160	NTclustered	gi\|507138087\|gb\|KC583131.1\|	590481	g6122	i0	98.769	91.4707692307692	325	4	100	0	1	325	420	96	Uncultured Amoebozoa clone RS.01f.10m.23 18S ribosomal RNA gene, partial sequence	blastn	29728	579	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
25243768	25243768	PRJNA1086823_P_NODE_8380_length_289_cov_1.083333_g8263_i0	PRJNA1086823	8380	289	1.083333	3.13083237	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	159	2.35e-48	NR	XP_004339588.1	1257118	g8263	i0	90.7	1.78546712802768	86	8	89.3	0	31	288	5	90	XP_004339588.1 60S ribosomal protein, putative [Acanthamoeba castellanii str. Neff]	diamond	516	159	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27312037	27312037	PRJNA1086823_P_NODE_12783_length_252_cov_0.871508_g12666_i0	PRJNA1086823	12783	252	0.871508	2.19620016	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	95.9	8.340000000000001e-21	NR	XP_004359899.1	261658	g12666	i0	51.8	1.97619047619048	83	39	98.8	1	251	3	861	942	XP_004359899.1 Acyloxyacyl hydrolase [Cavenderia fasciculata]	diamond	498	95.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
27406863	27406863	PRJNA1086823_P_NODE_15323_length_248_cov_0.891429_g15206_i0	PRJNA1086823	15323	248	0.891429	2.21074392	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	86.3	7.68e-19	NR	KYR01223.1	361077	g15206	i0	50	2.46774193548387	72	36	87.1	0	3	218	45	116	KYR01223.1 GTP-binding protein Sar1A [Tieghemostelium lacteum]	diamond	612	86.3	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
27573035	27573035	PRJNA1086823_P_NODE_8244_length_290_cov_1.313364_g8127_i0	PRJNA1086823	8244	290	1.313364	3.8087556	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	99.4	1.02e-24	NR	KAH3756107.1	1580589	g8127	i0	52.6	0.786206896551724	76	36	78.6	0	45	272	19	94	KAH3756107.1 hypothetical protein Pelo_12095 [Pelomyxa schiedti]	diamond	228	99.4	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
28267474	28267474	PRJNA1086823_P_NODE_1306_length_655_cov_1.594502_g1193_i0	PRJNA1086823	1306	655	1.594502	10.4439881	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	303	1.3899999999999998e-99	NR	XP_004353078.1	1257118	g1193	i0	68.2	2.97709923664122	217	68	99.4	1	3	653	136	351	XP_004353078.1 meiotic recombinase Dmc1, putative [Acanthamoeba castellanii str. Neff]	diamond	1950	303	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30920777	30920777	PRJNA1086823_P_NODE_12354_length_253_cov_0.866667_g12237_i0	PRJNA1086823	12354	253	0.866667	2.19266751	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	102	7.85e-24	NR	XP_004350112.1	261658	g12237	i0	61.9	0.99604743083004	84	31	99.6	1	1	252	176	258	XP_004350112.1 severin [Cavenderia fasciculata]	diamond	252	102	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata

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