metadata: contig_metadata: 26 rows where bioproject = "PRJNA1136957" and tax

26 rows where bioproject = "PRJNA1136957" 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
1559159	1559159	PRJNA1136957_S_NODE_14722_length_226_cov_1.455090_g14625_i0	PRJNA1136957	14722	226	1.45509	3.2885034	Metazoa	33208	Porifera	other_Eukaryota	93.6	3.83e-20	NR	XP_064404658.1	6063	g14625	i0	61.3	10.9646017699115	75	28	98.2	1	4	225	345	419	XP_064404658.1 cullin-5-like [Halichondria panicea]	diamond	2478	93.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
7937595	7937595	PRJNA1136957_S_NODE_1247_length_541_cov_37.053942_g1156_i0	PRJNA1136957	1247	541	37.053942	200.46182622	Dysidea avara	196820	Porifera	other_Eukaryota	139	9.53e-38	NR	XP_065911766.1	196820	g1156	i0	84	0.898336414048059	81	13	44.9	0	3	245	123	203	XP_065911766.1 peptidyl-prolyl cis-trans isomerase B-like [Dysidea avara]	diamond	486	139	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
11763258	11763258	PRJNA1136957_S_NODE_610_length_666_cov_47.820428_g535_i0	PRJNA1136957	610	666	47.820428	318.48405048	Sycon ciliatum	27933	Porifera	other_Eukaryota	250	2.19e-61	NTclustered	gi\|2732909594\|ref\|XM_065321551.1\|	27933	g535	i0	80.488	3.6966966966967	328	62	49	2	1	327	593	919	PREDICTED: Sycon ciliatum uncharacterized LOC135808368 (LOC135808368), mRNA	blastn	2462	250	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
13038319	13038319	PRJNA1136957_S_NODE_2491_length_445_cov_4.422280_g2394_i0	PRJNA1136957	2491	445	4.42228	19.679146	Oscarella lobularis	121494	Porifera	other_Eukaryota	84.2	1.53e-11	NTclustered	gi\|2746750598\|ref\|XM_065988700.1\|	121494	g2394	i0	85.185	1.05842696629213	81	12	18	0	1	81	468	548	PREDICTED: Oscarella lobularis splicing factor U2AF 35 kDa subunit-like (LOC136198688), mRNA	blastn	471	84.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
19410564	19410564	PRJNA1136957_S_NODE_76_length_1192_cov_39.519859_g55_i0	PRJNA1136957	76	1192	39.519859	471.07671928	Metazoa	33208	Porifera	other_Eukaryota	274	4.81e-88	NR	QIA61822.1	6063	g55	i0	77.8	5.10151006711409	171	38	43	0	10	522	1	171	QIA61822.1 ferritin heavy chain [Halichondria panicea]	diamond	6081	275	0.996363636363636	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
27312526	27312526	PRJNA1136957_S_NODE_15683_length_220_cov_1.136646_g15586_i0	PRJNA1136957	15683	220	1.136646	2.5006212	root	1	Root_unresolved	Root_unresolved	60.8	8.34e-9	NR	XP_065834985.1	121494	g15586	i0	72.2	2.53636363636364	36	10	49.1	0	36	143	67	102	XP_065834985.1 purine nucleoside phosphorylase-like isoform X2 [Oscarella lobularis]	diamond	558	60.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
27502003	27502003	PRJNA1136957_S_NODE_21603_length_186_cov_2.118110_g21506_i0	PRJNA1136957	21603	186	2.11811	3.9396846	Metazoa	33208	Porifera	other_Eukaryota	67.4	2.57e-12	NR	XP_065844604.1	121494	g21506	i0	60.3	6.54838709677419	58	23	93.5	0	186	13	81	138	XP_065844604.1 profilin-like [Oscarella lobularis]	diamond	1218	67.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
27607610	27607610	PRJNA1136957_S_NODE_6164_length_328_cov_1.312268_g6067_i0	PRJNA1136957	6164	328	1.312268	4.30423904	Sycon ciliatum	27933	Porifera	other_Eukaryota	109	1.78e-27	NR	XP_065185166.1	27933	g6067	i0	70.6	0.621951219512195	68	20	62.2	0	3	206	118	185	XP_065185166.1 dynactin subunit 5-like [Sycon ciliatum]	diamond	204	109	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
28112545	28112545	PRJNA1136957_S_NODE_5865_length_334_cov_1.996364_g5768_i0	PRJNA1136957	5865	334	1.996364	6.66785576	Sycon ciliatum	27933	Porifera	other_Eukaryota	63.9	3.99e-9	NR	XP_065176108.1	27933	g5768	i0	44.3	1.27544910179641	88	44	74.6	1	331	83	683	770	XP_065176108.1 condensin complex subunit 2-like [Sycon ciliatum]	diamond	426	63.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
28175619	28175619	PRJNA1136957_S_NODE_14586_length_227_cov_1.089286_g14489_i0	PRJNA1136957	14586	227	1.089286	2.47267922	Dysidea avara	196820	Porifera	other_Eukaryota	50.8	4.21e-5	NR	XP_065892073.1	196820	g14489	i0	52.3	0.581497797356828	44	21	58.1	0	134	3	134	177	XP_065892073.1 zinc finger BED domain-containing protein 4-like [Dysidea avara]	diamond	132	50.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
28575273	28575273	PRJNA1136957_S_NODE_4047_length_382_cov_4.835913_g3950_i0	PRJNA1136957	4047	382	4.835913	18.47318766	Metazoa	33208	Porifera	other_Eukaryota	114	1.15e-26	NR	XP_065176680.1	27933	g3950	i0	89.7	9.00785340314136	58	6	45.5	0	1	174	1110	1167	XP_065176680.1 DNA-directed RNA polymerase II subunit RPB2 [Sycon ciliatum]	diamond	3441	115	0.991304347826087	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
28606861	28606861	PRJNA1136957_S_NODE_9307_length_278_cov_1.648402_g9210_i0	PRJNA1136957	9307	278	1.648402	4.58255756	Metazoa	33208	Porifera	other_Eukaryota	47.4	0.00139	NR	XP_062522064.1	121492	g9210	i0	66.7	0.87410071942446	27	9	29.1	0	82	2	32	58	XP_062522064.1 filamin-C-like [Corticium candelabrum]	diamond	243	47.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
28649536	28649536	PRJNA1136957_S_NODE_11667_length_251_cov_1.270833_g11570_i0	PRJNA1136957	11667	251	1.270833	3.18979083	Dysidea avara	196820	Porifera	other_Eukaryota	135	4.06e-35	NR	XP_065906006.1	196820	g11570	i0	75.9	0.99203187250996006	83	20	99.2	0	250	2	86	168	XP_065906006.1 sterol carrier protein 2-like [Dysidea avara]	diamond	249	135	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
29438369	29438369	PRJNA1136957_S_NODE_13030_length_239_cov_1.066667_g12933_i0	PRJNA1136957	13030	239	1.066667	2.54933413	Sycon ciliatum	27933	Porifera	other_Eukaryota	118	7.480000000000001e-29	NR	XP_065187817.1	27933	g12933	i0	67.6	5.61087866108787	74	24	92.9	0	224	3	320	393	XP_065187817.1 uncharacterized protein LOC135818384 [Sycon ciliatum]	diamond	1341	118	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
29533497	29533497	PRJNA1136957_S_NODE_770_length_616_cov_28.833034_g692_i0	PRJNA1136957	770	616	28.833034	177.61148944	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	102	3.9099999999999996e-24	NR	XP_019859427.1	400682	g692	i0	51.6	0.886363636363636	91	44	44.3	0	616	344	6	96	XP_019859427.1 PREDICTED: protein PLANT CADMIUM RESISTANCE 2-like [Amphimedon queenslandica]	diamond	546	102	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
29596288	29596288	PRJNA1136957_S_NODE_11230_length_255_cov_2.801020_g11133_i0	PRJNA1136957	11230	255	2.80102	7.142601	Oscarella lobularis	121494	Porifera	other_Eukaryota	48.9	2.83e-4	NR	XP_065832962.1	121494	g11133	i0	36.5	0.870588235294118	74	47	87.1	0	2	223	442	515	XP_065832962.1 zinc finger protein 862-like [Oscarella lobularis]	diamond	222	48.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
29881019	29881019	PRJNA1136957_S_NODE_5291_length_347_cov_4.392361_g5194_i0	PRJNA1136957	5291	347	4.392361	15.24149267	Sycon ciliatum	27933	Porifera	other_Eukaryota	93.6	4.4900000000000005e-21	NR	XP_065189259.1	27933	g5194	i0	63.4	0.613832853025937	71	26	61.4	0	345	133	127	197	XP_065189259.1 COMM domain-containing protein 10-like [Sycon ciliatum]	diamond	213	93.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
30217327	30217327	PRJNA1136957_S_NODE_10552_length_263_cov_1.735294_g10455_i0	PRJNA1136957	10552	263	1.735294	4.56382322	Metazoa	33208	Porifera	other_Eukaryota	139	5.3999999999999995e-36	NR	XP_064406919.1	6063	g10455	i0	80.5	222.273764258555	87	17	99.2	0	261	1	8	94	XP_064406919.1 CCR4-NOT transcription complex subunit 3-like [Halichondria panicea]	diamond	58458	140	0.992857142857143	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30828627	30828627	PRJNA1136957_S_NODE_15194_length_223_cov_1.304878_g15097_i0	PRJNA1136957	15194	223	1.304878	2.90987794	Geodia barretti	519541	Porifera	other_Eukaryota	64.7	3.01e-11	NR	CAI7995912.1	519541	g15097	i0	59.6	6.12107623318386	52	21	70	0	161	6	15	66	CAI7995912.1 DNA-directed RNA polymerase III subunit RPC4 [Geodia barretti]	diamond	1365	64.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
30828629	30828629	PRJNA1136957_S_NODE_16854_length_212_cov_1.823529_g16757_i0	PRJNA1136957	16854	212	1.823529	3.86588148	Corticium candelabrum	121492	Porifera	other_Eukaryota	44.3	0.00402	NR	XP_062508871.1	121492	g16757	i0	41	0.863207547169811	61	34	83.5	1	179	3	36	96	XP_062508871.1 uncharacterized protein LOC134185096 [Corticium candelabrum]	diamond	183	44.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
31713878	31713878	PRJNA1136957_S_NODE_1017_length_572_cov_12.140351_g930_i0	PRJNA1136957	1017	572	12.140351	69.44280772	Geodia barretti	519541	Porifera	other_Eukaryota	51.6	7.31e-4	NR	CAI8008987.1	519541	g930	i0	52.9	0.267482517482518	51	24	26.7	0	60	212	1137	1187	CAI8008987.1 HHIP-like protein 1 [Geodia barretti]	diamond	153	51.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
32114330	32114330	PRJNA1136957_S_NODE_3918_length_386_cov_10.342508_g3821_i0	PRJNA1136957	3918	386	10.342508	39.92208088	Metazoa	33208	Porifera	other_Eukaryota	117	1.16e-30	NR	XP_064406547.1	6063	g3821	i0	96.2	18.979274611399	52	2	40.4	0	386	231	93	144	XP_064406547.1 protein BUD31 homolog [Halichondria panicea]	diamond	7326	117	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
32346916	32346916	PRJNA1136957_S_NODE_13239_length_237_cov_1.370787_g13142_i0	PRJNA1136957	13239	237	1.370787	3.24876519	Halichondria panicea	6063	Porifera	other_Eukaryota	53.9	4.53e-7	NR	XP_064389103.1	6063	g13142	i0	39	1.50632911392405	59	36	74.7	0	237	61	39	97	XP_064389103.1 uncharacterized protein LOC135337124 [Halichondria panicea]	diamond	357	53.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
32346920	32346920	PRJNA1136957_S_NODE_1939_length_477_cov_36.282297_g1842_i0	PRJNA1136957	1939	477	36.282297	173.06655669	Oscarella lobularis	121494	Porifera	other_Eukaryota	118	2.28e-30	NR	XP_065845146.1	121494	g1842	i0	73.4	0.993710691823899	79	21	49.7	0	477	241	100	178	XP_065845146.1 peroxiredoxin-5, mitochondrial-like [Oscarella lobularis]	diamond	474	118	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
32599690	32599690	PRJNA1136957_S_NODE_2960_length_422_cov_13.275482_g2863_i0	PRJNA1136957	2960	422	13.275482	56.02253404	Halichondria panicea	6063	Porifera	other_Eukaryota	182	1.8899999999999996e-55	NR	AZI95697.1	6063	g2863	i0	81.2	5.01895734597156	101	19	71.8	0	422	120	105	205	AZI95697.1 proteasome subunit beta 3, partial [Halichondria panicea]	diamond	2118	182	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
32651383	32651383	PRJNA1136957_S_NODE_17060_length_211_cov_1.203947_g16963_i0	PRJNA1136957	17060	211	1.203947	2.54032817	Metazoa	33208	Porifera	other_Eukaryota	89.4	3.51e-21	NR	XP_065186881.1	27933	g16963	i0	64.7	7.7345971563981	68	24	96.7	0	6	209	28	95	XP_065186881.1 microtubule nucleation factor SSNA1-like isoform X1 [Sycon ciliatum]	diamond	1632	90.1	0.992230854605993	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum

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