metadata: contig_metadata: 9 rows where bioproject = "PRJNA774958" and tax

9 rows where bioproject = "PRJNA774958" 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
11412132	11412132	PRJNA774958_P_NODE_36289_length_246_cov_0.890173_g36042_i0	PRJNA774958	36289	246	0.890173	2.18982558	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	152	2.13e-32	NTclustered	gi\|300078499\|gb\|GU001161.1\|	197531	g36042	i0	90.435	46.7560975609756	115	11	47	0	1	115	2181	2295	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	11502	152	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella septentrionalis
12687814	12687814	PRJNA774958_P_NODE_28790_length_281_cov_1.442308_g28543_i0	PRJNA774958	28790	281	1.442308	4.05288548	root	1	Root_unresolved	Root_unresolved	516	7.64e-142	NTclustered	gi\|909719646\|gb\|KT185626.1\|	5755	g28543	i0	100	51.1601423487544	279	0	99	0	3	281	3682	3960	Acanthamoeba castellanii 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	14376	516	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
19879674	19879674	PRJNA774958_P_NODE_656_length_1624_cov_5.715023_g586_i0	PRJNA774958	656	1624	5.715023	92.81197352	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	302	1.94e-90	NR	KAF2076314.1	133409	g586	i0	48.8	3.84790640394089	336	165	61.3	3	1342	347	126	458	KAF2076314.1 hypothetical protein CYY_002370 [Polysphondylium violaceum]	diamond	6249	302	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
26641799	26641799	PRJNA774958_P_NODE_19641_length_361_cov_1.600694_g19394_i0	PRJNA774958	19641	361	1.600694	5.77850534	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	59.7	1.72e-7	NR	XP_636129.1	352472	g19394	i0	37.4	4.05540166204986	99	58	78.9	1	1	285	796	894	XP_636129.1 leucine-rich repeat-containing protein [Dictyostelium discoideum AX4]	diamond	1464	59.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
26958244	26958244	PRJNA774958_P_NODE_14022_length_435_cov_1.276243_g13775_i0	PRJNA774958	14022	435	1.276243	5.55165705	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	142	2.3e-36	NR	XP_004360542.1	261658	g13775	i0	48.6	12.6137931034483	138	70	95.2	1	20	433	472	608	XP_004360542.1 putative RNA helicase [Cavenderia fasciculata]	diamond	5487	142	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
27590692	27590692	PRJNA774958_P_NODE_16864_length_395_cov_1.167702_g16617_i0	PRJNA774958	16864	395	1.167702	4.6124229	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	57.4	1.61e-6	NR	KAF2070217.1	133409	g16617	i0	34.5	2.68101265822785	139	72	99.5	4	395	3	1798	1925	KAF2070217.1 hypothetical protein CYY_008463 [Polysphondylium violaceum]	diamond	1059	57.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
29547893	29547893	PRJNA774958_P_NODE_39370_length_230_cov_3.662420_g39123_i0	PRJNA774958	39370	230	3.66242	8.423566	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	57.4	9.54e-9	NR	PRP79013.1	1890364	g39123	i0	45.5	3	55	30	71.7	0	176	12	23	77	PRP79013.1 component of scar regulatory complex [Planoprotostelium fungivorum]	diamond	690	57.4	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
29642464	29642464	PRJNA774958_P_NODE_15650_length_410_cov_2.136499_g15403_i0	PRJNA774958	15650	410	2.136499	8.7596459	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	46.2	0.002	NR	KYQ92517.1	361077	g15403	i0	34	1.8	53	35	38.8	0	130	288	40	92	KYQ92517.1 cytochrome c oxidase subunit VIb [Tieghemostelium lacteum]	diamond	738	46.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
31570585	31570585	PRJNA774958_P_NODE_29636_length_275_cov_1.905941_g29389_i0	PRJNA774958	29636	275	1.905941	5.24133775	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	52.8	1.65e-5	NR	KYQ89485.1	361077	g29389	i0	37.2	2.01818181818182	94	54	99.3	3	275	3	788	879	KYQ89485.1 hypothetical protein DLAC_10160 [Tieghemostelium lacteum]	diamond	555	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum

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