metadata: contig_metadata: 5 rows where bioproject = "PRJNA1086823", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA1086823", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
11672546	11672546	PRJNA1086823_P_NODE_5370_length_346_cov_0.846154_g5253_i0	PRJNA1086823	5370	346	0.846154	2.92769284	Metazoa	33208	Porifera	other_Eukaryota	171	1.69e-52	NR	XP_065826293.1	121494	g5253	i0	79.2	3.32947976878613	96	20	83.2	0	1	288	35	130	XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis]	diamond	1152	171	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
26963868	26963868	PRJNA1086823_P_NODE_19022_length_242_cov_0.923077_g18905_i0	PRJNA1086823	19022	242	0.923077	2.23384634	Metazoa	33208	Porifera	other_Eukaryota	116	3.37e-30	NR	XP_065909141.1	196820	g18905	i0	68.8	68.4173553719008	80	25	99.2	0	241	2	8	87	XP_065909141.1 proteasome subunit alpha type-5-like [Dysidea avara]	diamond	16557	117	0.991452991452991	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
29751369	29751369	PRJNA1086823_P_NODE_13771_length_251_cov_0.865169_g13654_i0	PRJNA1086823	13771	251	0.865169	2.17157419	Geodia barretti	519541	Porifera	other_Eukaryota	89.4	4.11e-20	NR	CAI8030757.1	519541	g13654	i0	55.2	1.0398406374502	87	30	98	3	249	4	78	160	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	261	89.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
31204499	31204499	PRJNA1086823_P_NODE_18895_length_242_cov_0.923077_g18778_i0	PRJNA1086823	18895	242	0.923077	2.23384634	Halichondria panicea	6063	Porifera	other_Eukaryota	95.9	1.73e-21	NR	XP_064392077.1	6063	g18778	i0	56.3	1.98347107438017	80	34	99.2	1	242	3	75	153	XP_064392077.1 serine dehydratase-like [Halichondria panicea]	diamond	480	95.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
31995777	31995777	PRJNA1086823_P_NODE_2258_length_502_cov_3.682984_g2141_i0	PRJNA1086823	2258	502	3.682984	18.48857968	Geodia barretti	519541	Porifera	other_Eukaryota	134	1.52e-36	NR	CAI8030757.1	519541	g2141	i0	52.3	0.902390438247012	151	57	86.1	6	433	2	18	160	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	453	134	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti

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