metadata: contig_metadata: 6 rows where bioproject = "PRJNA801875", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA801875", 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
7599879	7599879	PRJNA801875_P_NODE_26_length_2380_cov_15.978252_g10_i0	PRJNA801875	26	2380	15.978252	380.2823976	Mycale	86015	Porifera	other_Eukaryota	176	1.4e-38	NTclustered	gi\|514227091\|gb\|KC961671.1\|	458504	g10	i0	83.333	9.04075630252101	198	25	8	6	735	929	289	97	Mycale laxissima voucher UERJ4 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	21517	176	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Poecilosclerida	Mycalidae	Mycale	Mycale laxissima
16103619	16103619	PRJNA801875_P_NODE_4693_length_151_cov_1.413793_g4590_i0	PRJNA801875	4693	151	1.413793	2.13482743	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	85.5	3.21e-19	NR	CAI8006937.1	519541	g4590	i0	73.5	16.4304635761589	49	13	97.4	0	4	150	119	167	CAI8006937.1 Eukaryotic initiation factor 4A-II [Geodia barretti]	diamond	2481	85.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
21203471	21203471	PRJNA801875_P_NODE_477_length_639_cov_3.296358_g377_i0	PRJNA801875	477	639	3.296358	21.06372762	Geodia barretti	519541	Porifera	other_Eukaryota	255	4.58e-83	NR	CAI8032315.1	519541	g377	i0	65.2	5.76525821596244	204	66	94.4	2	11	613	1	202	CAI8032315.1 40S ribosomal protein S8 [Geodia barretti]	diamond	3684	255	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
23753729	23753729	PRJNA801875_P_NODE_1299_length_350_cov_1.888889_g1196_i0	PRJNA801875	1299	350	1.888889	6.6111115	Oscarella lobularis	121494	Porifera	other_Eukaryota	188	3.47e-59	NR	XP_065826293.1	121494	g1196	i0	77.4	55.3371428571429	115	26	98.6	0	3	347	7	121	XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis]	diamond	19368	188	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
29968301	29968301	PRJNA801875_P_NODE_1551_length_307_cov_4.389706_g1448_i0	PRJNA801875	1551	307	4.389706	13.47639742	Metazoa	33208	Porifera	other_Eukaryota	139	3.79e-39	NR	AAX48885.1	55567	g1448	i0	77.7	17.7166123778502	94	21	91.9	0	5	286	92	185	AAX48885.1 S9 [Suberites domuncula]	diamond	5439	140	0.992857142857143	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
31855737	31855737	PRJNA801875_P_NODE_3277_length_182_cov_1.748299_g3174_i0	PRJNA801875	3277	182	1.748299	3.18190418	Corticium candelabrum	121492	Porifera	other_Eukaryota	79	2.83e-15	NR	XP_062503430.1	121492	g3174	i0	60	0.906593406593407	55	22	90.7	0	5	169	365	419	XP_062503430.1 uncharacterized protein LOC134180315 [Corticium candelabrum]	diamond	165	79	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum

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