metadata: contig_metadata: 5 rows where bioproject = "PRJNA609258" and tax

5 rows where bioproject = "PRJNA609258" 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
587833	587833	PRJNA609258_P_NODE_53721_length_249_cov_0.886364_g53336_i0	PRJNA609258	53721	249	0.886364	2.20704636	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	76.8	1.34e-9	NTclustered	gi\|330802308\|ref\|XM_003289113.1\|	5786	g53336	i0	91.071	0.634538152610442	56	5	22	0	156	211	1	56	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_48405), partial mRNA	blastn	158	76.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
8239912	8239912	PRJNA609258_P_NODE_25447_length_373_cov_6.436667_g25063_i0	PRJNA609258	25447	373	6.436667	24.00876791	uncultured Rhizamoeba	1260765	Tubulinea	other_Eukaryota	84.2	1.26e-11	NTclustered	gi\|511487963\|gb\|JX898537.1\|	1260765	g25063	i0	91.667	0.276139410187668	60	5	16	0	42	101	309	250	Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence	blastn	103	84.2	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae		uncultured Rhizamoeba
19714254	19714254	PRJNA609258_P_NODE_49896_length_253_cov_0.866667_g49511_i0	PRJNA609258	49896	253	0.866667	2.19266751	Cavostelium apophysatum	435410	Evosea	other_Eukaryota	261	3.5e-65	NTclustered	gi\|146448837\|gb\|EF513185.1\|	435410	g49511	i0	85.375	96.3359683794466	253	35	99	2	2	253	594	343	Cavostelium apophysatum elongation factor 1A (EF1A) gene, partial cds	blastn	24373	261	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Cavostelium	Cavostelium apophysatum
28880082	28880082	PRJNA609258_P_NODE_50588_length_252_cov_0.871508_g50203_i0	PRJNA609258	50588	252	0.871508	2.19620016	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	82	6.06e-16	NR	XP_004339599.1	1257118	g50203	i0	60.6	0.845238095238095	71	27	83.3	1	245	36	540	610	XP_004339599.1 Ubox domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	213	82	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30269981	30269981	PRJNA609258_P_NODE_50912_length_252_cov_0.871508_g50527_i0	PRJNA609258	50912	252	0.871508	2.19620016	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	80.9	1.66e-15	NR	XP_003287080.1	5786	g50527	i0	62.1	0.69047619047619	58	22	69	0	76	249	685	742	XP_003287080.1 uncharacterized protein DICPUDRAFT_151152 [Dictyostelium purpureum]	diamond	174	80.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum

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