metadata: contig_metadata: 7 rows where bioproject = "PRJNA554794" and tax

7 rows where bioproject = "PRJNA554794" 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
14549970	14549970	PRJNA554794_P_NODE_23092_length_165_cov_1.017241_g19163_i0	PRJNA554794	23092	165	1.017241	1.67844765	Sycon ciliatum	27933	Porifera	other_Eukaryota	117	4.82e-22	NTclustered	gi\|2732934263\|ref\|XM_065334202.1\|	27933	g19163	i0	80.247	0.981818181818182	162	26	96	6	7	165	472	314	PREDICTED: Sycon ciliatum large ribosomal subunit protein uL3-like (LOC135821136), mRNA	blastn	162	117	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
18372676	18372676	PRJNA554794_P_NODE_21615_length_178_cov_0.930233_g17686_i0	PRJNA554794	21615	178	0.930233	1.65581474	Sycon ciliatum	27933	Porifera	other_Eukaryota	106	1.14e-18	NTclustered	gi\|2732914053\|ref\|XM_065323850.1\|	27933	g17686	i0	79.31	1.2247191011236	174	19	89	10	2	159	1153	1325	PREDICTED: Sycon ciliatum plastin-3-like (LOC135810357), mRNA	blastn	218	106	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
21525666	21525666	PRJNA554794_P_NODE_3117_length_1691_cov_5.038368_g1154_i0	PRJNA554794	3117	1691	5.038368	85.19880288	Mycale	86015	Porifera	other_Eukaryota	176	9.9e-39	NTclustered	gi\|514227091\|gb\|KC961671.1\|	458504	g1154	i0	83.333	12.929627439385	198	25	12	6	58	252	289	97	Mycale laxissima voucher UERJ4 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	21864	176	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Poecilosclerida	Mycalidae	Mycale	Mycale laxissima
27647105	27647105	PRJNA554794_P_NODE_23284_length_165_cov_0.870690_g19355_i0	PRJNA554794	23284	165	0.87069	1.4366385	Sycon ciliatum	27933	Porifera	other_Eukaryota	46.2	7.57e-4	NR	XP_065183684.1	27933	g19355	i0	47.1	0.927272727272727	51	26	92.7	1	154	2	308	357	XP_065183684.1 lipid droplet-regulating VLDL assembly factor AUP1-like [Sycon ciliatum]	diamond	153	46.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
29477865	29477865	PRJNA554794_P_NODE_22790_length_166_cov_1.299145_g18861_i0	PRJNA554794	22790	166	1.299145	2.1565807	Oscarella lobularis	121494	Porifera	other_Eukaryota	93.2	1e-20	NR	XP_065832878.1	121494	g18861	i0	74.5	1.8433734939759	51	13	92.2	0	164	12	187	237	XP_065832878.1 cathepsin B-like cysteine proteinase 4 [Oscarella lobularis]	diamond	306	93.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
30914460	30914460	PRJNA554794_P_NODE_22214_length_171_cov_1.155738_g18285_i0	PRJNA554794	22214	171	1.155738	1.97631198	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	94	1.36e-22	NR	XP_064400434.1	6063	g18285	i0	84.3	20.4912280701754	51	8	89.5	0	2	154	44	94	XP_064400434.1 small ribosomal subunit protein eS10-like [Halichondria panicea]	diamond	3504	94.4	0.995762711864407	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
32386188	32386188	PRJNA554794_P_NODE_12079_length_287_cov_1.710084_g8150_i0	PRJNA554794	12079	287	1.710084	4.90794108	Oopsacas minuta	111878	Porifera	other_Eukaryota	82	4.33e-16	NR	KAI6656663.1	111878	g8150	i0	48.3	0.930313588850174	89	41	93	1	282	16	1	84	KAI6656663.1 Cathepsin L [Oopsacas minuta]	diamond	267	82	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta

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