metadata: contig_metadata: 10 rows where bioproject = "PRJNA512103" and tax

10 rows where bioproject = "PRJNA512103" 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
4939098	4939098	PRJNA512103_P_NODE_17304_length_237_cov_1.202128_g16892_i0	PRJNA512103	17304	237	1.202128	2.84904336	Ripella	1217112	Discosea	other_Eukaryota	412	8.47e-111	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g16892	i0	100	93.7932489451477	223	0	94	0	10	232	448	226	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	22229	412	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
6863346	6863346	PRJNA512103_P_NODE_13826_length_285_cov_1.788136_g13414_i0	PRJNA512103	13826	285	1.788136	5.0961876	Vannella septentrionalis	197531	Discosea	other_Eukaryota	460	3.69e-125	NTclustered	gi\|300078499\|gb\|GU001161.1\|	197531	g13414	i0	96.739	93.7649122807018	276	9	97	0	1	276	1620	1895	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	26723	460	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella septentrionalis
6863812	6863812	PRJNA512103_P_NODE_26266_length_183_cov_1.686567_g25854_i0	PRJNA512103	26266	183	1.686567	3.08641761	Vannella sp. KDN1	2081467	Discosea	other_Eukaryota	302	1.4e-77	NTclustered	gi\|1770511914\|dbj\|LC368142.1\|	2081467	g25854	i0	98.817	84.6830601092896	169	2	92	0	6	174	1375	1543	Vannella sp. KDN1 gene for 18S ribosomal RNA, partial sequence	blastn	15497	302	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. KDN1
8138569	8138569	PRJNA512103_P_NODE_12407_length_314_cov_1.637736_g11995_i0	PRJNA512103	12407	314	1.637736	5.14249104	Pellita digitata	1485084	Discosea	other_Eukaryota	322	2.03e-83	NTclustered	gi\|608606231\|gb\|KF705038.1\|	1485084	g11995	i0	89.015	68.4140127388535	264	23	84	4	42	305	392	649	Pellita digitata clone 3 18S ribosomal RNA gene, partial sequence	blastn	21482	322	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Pellitidae	Pellita	Pellita digitata
15789311	15789311	PRJNA512103_P_NODE_9893_length_380_cov_1.111782_g9481_i0	PRJNA512103	9893	380	1.111782	4.2247716	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	52.8	0.036	NTclustered	gi\|66819454\|ref\|XM_638295.1\|	352472	g9481	i0	100	0.0736842105263158	28	0	7	0	309	336	3349	3322	Dictyostelium discoideum AX4 RasGEF domain-containing protein (gefY) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
18962476	18962476	PRJNA512103_P_NODE_12015_length_323_cov_1.178832_g11603_i0	PRJNA512103	12015	323	1.178832	3.80762736	Vannella	95228	Discosea	other_Eukaryota	566	8.759999999999998e-157	NTclustered	gi\|399764252\|gb\|JQ271763.1\|	1215667	g11603	i0	100	93.687306501548	306	0	95	0	10	315	1563	1868	Vannella sp. SEDFS 18S ribosomal RNA gene, partial sequence	blastn	30261	566	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. SEDFS
20888102	20888102	PRJNA512103_P_NODE_25917_length_185_cov_0.963235_g25505_i0	PRJNA512103	25917	185	0.963235	1.78198475	Ripella sp. 805	1217113	Discosea	other_Eukaryota	292	8.55e-75	NTclustered	gi\|399764202\|gb\|JQ271713.1\|	1217113	g25505	i0	96.629	81.827027027027	178	3	95	3	10	185	830	654	Ripella sp. 805 18S ribosomal RNA gene, partial sequence	blastn	15138	292	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella sp. 805
21512819	21512819	PRJNA512103_P_NODE_8617_length_425_cov_4.183511_g8206_i0	PRJNA512103	8617	425	4.183511	17.77992175	Vannella	95228	Discosea	other_Eukaryota	749	0	NTclustered	gi\|399764218\|gb\|JQ271729.1\|	1215633	g8206	i0	99.513	95.3294117647059	411	2	97	0	10	420	182	592	Vannella sp. CAME 18S ribosomal RNA gene, partial sequence	blastn	40515	749	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. CAME
31134894	31134894	PRJNA512103_P_NODE_20395_length_212_cov_1.073620_g19983_i0	PRJNA512103	20395	212	1.07362	2.2760744	root	1	Root_unresolved	Root_unresolved	93.6	3.12e-20	NR	XP_003285278.1	5786	g19983	i0	65.7	6.80660377358491	67	23	94.8	0	205	5	658	724	XP_003285278.1 alanyl-tRNA synthetase [Dictyostelium purpureum]	diamond	1443	93.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
32575141	32575141	PRJNA512103_P_NODE_30759_length_169_cov_0.866667_g30347_i0	PRJNA512103	30759	169	0.866667	1.46466723	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	55.8	1.55e-7	NR	PRP76595.1	1890364	g30347	i0	69.4	0.63905325443787	36	11	63.9	0	52	159	97	132	PRP76595.1 ras-related protein Rab-21-like [Planoprotostelium fungivorum]	diamond	108	55.8	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum

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