metadata: contig_metadata: 8 rows where bioproject = "PRJNA576995", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA576995", 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
10764900	10764900	PRJNA576995_P_NODE_24589_length_308_cov_1.251064_g23997_i0	PRJNA576995	24589	308	1.251064	3.85327712	Geodia barretti	519541	Porifera	other_Eukaryota	178	5.829999999999998e-55	NR	CAI8045466.1	519541	g23997	i0	82.4	105.311688311688	102	18	99.4	0	308	3	18	119	CAI8045466.1 60S ribosomal protein L11 [Geodia barretti]	diamond	32436	178	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
14589767	14589767	PRJNA576995_P_NODE_5812_length_669_cov_1.761745_g5240_i0	PRJNA576995	5812	669	1.761745	11.78607405	Metazoa	33208	Porifera	other_Eukaryota	199	4.27e-58	NR	XP_065831310.1	121494	g5240	i0	53.5	6.31838565022422	202	84	87.9	7	79	666	6	203	XP_065831310.1 nucleoredoxin-like [Oscarella lobularis]	diamond	4227	199	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
17138182	17138182	PRJNA576995_P_NODE_18014_length_353_cov_2.050000_g17422_i0	PRJNA576995	18014	353	2.05	7.2365	Oscarella lobularis	121494	Porifera	other_Eukaryota	67.4	2.85e-10	NR	XP_065833742.1	121494	g17422	i0	42.3	2.92351274787535	97	54	80.7	2	4	288	296	392	XP_065833742.1 lysosome membrane protein 2-like [Oscarella lobularis]	diamond	1032	67.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
26636352	26636352	PRJNA576995_P_NODE_29161_length_282_cov_3.234450_g28569_i0	PRJNA576995	29161	282	3.23445	9.121149	Sycon ciliatum	27933	Porifera	other_Eukaryota	45.1	0.00847	NR	XP_065186432.1	27933	g28569	i0	41.7	0.765957446808511	72	39	74.5	3	241	32	26	96	XP_065186432.1 cathepsin B-like [Sycon ciliatum]	diamond	216	45.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
27047999	27047999	PRJNA576995_P_NODE_28502_length_286_cov_1.253521_g27910_i0	PRJNA576995	28502	286	1.253521	3.58507006	Sycon ciliatum	27933	Porifera	other_Eukaryota	54.7	3.86e-6	NR	XP_065175186.1	27933	g27910	i0	39.4	1.57342657342657	94	46	94.4	3	272	3	558	644	XP_065175186.1 integrin beta-1-A-like isoform X2 [Sycon ciliatum]	diamond	450	54.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
30142428	30142428	PRJNA576995_P_NODE_39752_length_246_cov_0.878613_g39160_i0	PRJNA576995	39752	246	0.878613	2.16138798	Dysidea avara	196820	Porifera	other_Eukaryota	45.1	0.00628	NR	XP_065916481.1	196820	g39160	i0	35.1	0.939024390243902	77	47	90.2	1	22	243	2071	2147	XP_065916481.1 spectrin alpha chain, non-erythrocytic 1-like [Dysidea avara]	diamond	231	45.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
30806325	30806325	PRJNA576995_P_NODE_43034_length_241_cov_0.916667_g42442_i0	PRJNA576995	43034	241	0.916667	2.20916747	Corticium candelabrum	121492	Porifera	other_Eukaryota	94	3.06e-20	NR	XP_062504214.1	121492	g42442	i0	49.4	17.9502074688797	81	40	99.6	1	1	240	5	85	XP_062504214.1 myb-related protein B-like isoform X2 [Corticium candelabrum]	diamond	4326	94	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
32007847	32007847	PRJNA576995_P_NODE_38238_length_247_cov_1.304598_g37646_i0	PRJNA576995	38238	247	1.304598	3.22235706	Oscarella lobularis	121494	Porifera	other_Eukaryota	48.9	2.67e-4	NR	XP_065830295.1	121494	g37646	i0	35.4	1.68825910931174	79	47	91.1	1	246	22	290	368	XP_065830295.1 uncharacterized protein [Oscarella lobularis]	diamond	417	48.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis

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