metadata: contig_metadata: 14 rows where bioproject = "PRJNA870096" and tax

14 rows where bioproject = "PRJNA870096" 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
10165850	10165850	PRJNA870096_S_NODE_16648_length_447_cov_22.428218_g15002_i0	PRJNA870096	16648	447	22.428218	100.25413446	Opisthokonta	33154	Porifera	other_Eukaryota	68.9	7.21e-12	NR	XP_003391081.1	400682	g15002	i0	47.9	3.6510067114094	71	36	47.7	1	52	264	1	70	XP_003391081.1 PREDICTED: 60S acidic ribosomal protein P2-like [Amphimedon queenslandica]	diamond	1632	69.3	0.994227994227994	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
22526424	22526424	PRJNA870096_S_NODE_133138_length_155_cov_1.008929_g131474_i0	PRJNA870096	133138	155	1.008929	1.56383995	Suberites domuncula	55567	Porifera	other_Eukaryota	176	7.25e-40	NTclustered	gi\|4150911\|emb\|Y12081.1\|	55567	g131474	i0	89.362	160.845161290323	141	14	93	1	9	149	682	543	Suberites domuncula mRNA for polyubiquitin precursor	blastn	24931	176	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
22914861	22914861	PRJNA870096_S_NODE_121458_length_161_cov_3.593220_g119794_i0	PRJNA870096	121458	161	3.59322	5.7850842	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	89.7	3.59e-20	NR	XP_003384382.1	400682	g119794	i0	80.8	0.968944099378882	52	10	96.9	0	5	160	172	223	XP_003384382.1 PREDICTED: dolichol-phosphate mannosyltransferase subunit 1-like [Amphimedon queenslandica]	diamond	156	89.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
23802101	23802101	PRJNA870096_S_NODE_22639_length_379_cov_13.404762_g20978_i0	PRJNA870096	22639	379	13.404762	50.80404798	Metazoa	33208	Porifera	other_Eukaryota	127	1.1999999999999999e-32	NR	Q4KTE2.1	55567	g20978	i0	56.7	4.18733509234828	127	45	95.8	5	1	363	139	261	Q4KTE2.1 RecName: Full=Small ribosomal subunit protein uS2; AltName: Full=40S ribosomal protein SA [Suberites domuncula]	diamond	1587	127	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
23802113	23802113	PRJNA870096_S_NODE_23899_length_369_cov_2.355828_g22236_i0	PRJNA870096	23899	369	2.355828	8.69300532	Dysidea avara	196820	Porifera	other_Eukaryota	54.7	0.01	NTclustered	gi\|2749556513\|ref\|XM_066045316.1\|	196820	g22236	i0	100	0.0785907859078591	29	0	8	0	251	279	1370	1342	PREDICTED: Dysidea avara uncharacterized protein (LOC136252751), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
26778565	26778565	PRJNA870096_S_NODE_34621_length_303_cov_4.350000_g32957_i0	PRJNA870096	34621	303	4.35	13.1805	Metazoa	33208	Porifera	other_Eukaryota	72	4.29e-13	NR	XP_065199288.1	27933	g32957	i0	51.9	2.30693069306931	77	34	75.2	2	287	60	108	182	XP_065199288.1 ras-related protein Rap-1b [Sycon ciliatum]	diamond	699	72.4	0.994475138121547	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
26873750	26873750	PRJNA870096_S_NODE_41641_length_275_cov_1.353448_g39977_i0	PRJNA870096	41641	275	1.353448	3.721982	Metazoa	33208	Porifera	other_Eukaryota	103	4.11e-25	NR	XP_062510410.1	121492	g39977	i0	54.5	1.95272727272727	88	38	93.8	1	275	18	116	203	XP_062510410.1 transcription elongation factor SPT4-A-like [Corticium candelabrum]	diamond	537	104	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
26897151	26897151	PRJNA870096_S_NODE_23661_length_371_cov_2.195122_g21998_i0	PRJNA870096	23661	371	2.195122	8.14390262	Sycon ciliatum	27933	Porifera	other_Eukaryota	149	4.499999999999999e-43	NR	XP_065184707.1	27933	g21998	i0	59	1.96495956873315	122	48	97	2	370	11	50	171	XP_065184707.1 actin-related protein 2/3 complex subunit 3-like [Sycon ciliatum]	diamond	729	149	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
27347948	27347948	PRJNA870096_S_NODE_49583_length_250_cov_1.792271_g47919_i0	PRJNA870096	49583	250	1.792271	4.4806775	Metazoa	33208	Porifera	other_Eukaryota	64.3	1.08e-10	NR	CAA76405.1	6047	g47919	i0	36.6	1.956	82	51	97.2	1	6	248	63	144	CAA76405.1 calmodulin [Geodia cydonium]	diamond	489	64.7	0.993817619783617	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia cydonium
28602781	28602781	PRJNA870096_S_NODE_35687_length_298_cov_5.709804_g34023_i0	PRJNA870096	35687	298	5.709804	17.01521592	Corticium candelabrum	121492	Porifera	other_Eukaryota	48.1	5.28e-4	NR	XP_062515712.1	121492	g34023	i0	35.6	3.59395973154362	90	57	90.6	1	18	287	90	178	XP_062515712.1 clathrin light chain B-like [Corticium candelabrum]	diamond	1071	48.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
28823396	28823396	PRJNA870096_S_NODE_37028_length_293_cov_1.252000_g35364_i0	PRJNA870096	37028	293	1.252	3.66836	Oscarella lobularis	121494	Porifera	other_Eukaryota	49.7	2.58e-4	NR	XP_065826769.1	121494	g35364	i0	54.3	0.47098976109215	46	19	45.1	1	160	291	3448	3493	XP_065826769.1 serine/threonine-protein kinase SMG1-like [Oscarella lobularis]	diamond	138	49.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
31168888	31168888	PRJNA870096_S_NODE_127295_length_158_cov_1.252174_g125631_i0	PRJNA870096	127295	158	1.252174	1.97843492	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	63.5	5.28e-10	NR	XP_065834556.1	121494	g125631	i0	55.8	3.9493670886076	52	23	98.7	0	156	1	391	442	XP_065834556.1 dnaJ homolog subfamily C member 7-like [Oscarella lobularis]	diamond	624	63.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
31224040	31224040	PRJNA870096_S_NODE_118555_length_163_cov_2.116667_g116891_i0	PRJNA870096	118555	163	2.116667	3.45016721	Sycon ciliatum	27933	Porifera	other_Eukaryota	67.4	4.12e-13	NR	XP_065176325.1	27933	g116891	i0	57.1	3.49693251533742	49	21	90.2	0	163	17	25	73	XP_065176325.1 signal recognition particle 9 kDa protein-like [Sycon ciliatum]	diamond	570	67.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32489835	32489835	PRJNA870096_S_NODE_66439_length_215_cov_1.395349_g64775_i0	PRJNA870096	66439	215	1.395349	3.00000035	Sycon ciliatum	27933	Porifera	other_Eukaryota	48.9	1.69e-4	NR	XP_065187940.1	27933	g64775	i0	37.3	0.934883720930233	67	41	92.1	1	4	201	28	94	XP_065187940.1 prosaposin-like [Sycon ciliatum]	diamond	201	48.9	1	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);;