metadata: contig_metadata: 15 rows where bioproject = "PRJNA1005695", tax_kingdom = "Metazoa" and tax

15 rows where bioproject = "PRJNA1005695", 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
153515	153515	PRJNA1005695_P_NODE_26401_length_291_cov_2.119266_g25549_i0	PRJNA1005695	26401	291	2.119266	6.16706406	Metazoa	33208	Porifera	other_Eukaryota	196	1.02e-61	NR	XP_065916610.1	196820	g25549	i0	97.9	155.989690721649	97	2	100	0	291	1	17	113	XP_065916610.1 ras-related protein Rab-14 [Dysidea avara]	diamond	45393	196	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
5256491	5256491	PRJNA1005695_P_NODE_32645_length_261_cov_1.351064_g31793_i0	PRJNA1005695	32645	261	1.351064	3.52627704	Opisthokonta	33154	Porifera	other_Eukaryota	99.8	3.32e-22	NR	KAI6660239.1	111878	g31793	i0	84.9	18.2413793103448	53	8	60.9	0	161	3	164	216	KAI6660239.1 Serine/threonine-protein kinase RIO1-like [Oopsacas minuta]	diamond	4761	99.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
15456177	15456177	PRJNA1005695_P_NODE_29213_length_276_cov_2.778325_g28361_i0	PRJNA1005695	29213	276	2.778325	7.668177	Corticium candelabrum	121492	Porifera	other_Eukaryota	141	4.2099999999999995e-37	NR	XP_062522682.1	121492	g28361	i0	68.1	0.989130434782609	91	29	98.9	0	276	4	168	258	XP_062522682.1 thioredoxin reductase 1, cytoplasmic-like [Corticium candelabrum]	diamond	273	141	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
21403283	21403283	PRJNA1005695_P_NODE_42157_length_217_cov_4.520833_g41305_i0	PRJNA1005695	42157	217	4.520833	9.81020761	Tetractinellida	1779164	Porifera	other_Eukaryota	132	2.39e-26	NTclustered	gi\|512765374\|gb\|KC869612.1\|	1183873	g41305	i0	86.777	53.5483870967742	121	13	55	2	57	176	2144	2026	Stelletta fibrosa voucher P24 28S ribosomal RNA gene, partial sequence	blastn	11620	132	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia fibrosa
25227378	25227378	PRJNA1005695_P_NODE_37720_length_246_cov_3.861272_g36868_i0	PRJNA1005695	37720	246	3.861272	9.49872912	Metazoa	33208	Porifera	other_Eukaryota	149	1.19e-39	NR	XP_065194115.1	27933	g36868	i0	84	40.5609756097561	81	13	98.8	0	243	1	502	582	XP_065194115.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3A-like [Sycon ciliatum]	diamond	9978	149	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
27026957	27026957	PRJNA1005695_P_NODE_6662_length_609_cov_2.492537_g5831_i0	PRJNA1005695	6662	609	2.492537	15.17955033	Metazoa	33208	Porifera	other_Eukaryota	179	1.47e-49	NR	XP_064390129.1	6063	g5831	i0	55.3	17.1428571428571	159	70	78.3	1	481	5	18	175	XP_064390129.1 T-complex protein 1 subunit gamma-like [Halichondria panicea]	diamond	10440	179	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28543171	28543171	PRJNA1005695_P_NODE_33087_length_259_cov_1.655914_g32235_i0	PRJNA1005695	33087	259	1.655914	4.28881726	Metazoa	33208	Porifera	other_Eukaryota	47.4	7.05e-4	NR	XP_064393368.1	6063	g32235	i0	43.6	3.37065637065637	55	31	63.7	0	76	240	39	93	XP_064393368.1 protein DGCR6-like [Halichondria panicea]	diamond	873	47.8	0.99163179916318	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
29497603	29497603	PRJNA1005695_P_NODE_34450_length_253_cov_1.788889_g33598_i0	PRJNA1005695	34450	253	1.788889	4.52588917	Geodia barretti	519541	Porifera	other_Eukaryota	68.2	1.84e-11	NR	CAI8057344.1	519541	g33598	i0	42.9	9.96047430830039	84	39	99.6	2	252	1	87	161	CAI8057344.1 Histone deacetylase 2 [Geodia barretti]	diamond	2520	68.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
30034578	30034578	PRJNA1005695_P_NODE_26671_length_290_cov_1.078341_g25819_i0	PRJNA1005695	26671	290	1.078341	3.1271889	Suberites domuncula	55567	Porifera	other_Eukaryota	127	2.28e-34	NR	CAP19646.1	55567	g25819	i0	62.9	6.02068965517241	97	35	99.3	1	288	1	19	115	CAP19646.1 thymidine kinase [Suberites domuncula]	diamond	1746	127	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
30280227	30280227	PRJNA1005695_P_NODE_9272_length_512_cov_2.656036_g8423_i0	PRJNA1005695	9272	512	2.656036	13.59890432	root	1	Root_unresolved	Root_unresolved	72.4	2.51e-11	NR	XP_065188515.1	27933	g8423	i0	37.1	1.46484375	124	74	70.3	3	151	510	101	224	XP_065188515.1 uncharacterized protein LOC135819268 [Sycon ciliatum]	diamond	750	72.8	0.994505494505495	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
30982503	30982503	PRJNA1005695_P_NODE_24534_length_303_cov_1.630435_g23682_i0	PRJNA1005695	24534	303	1.630435	4.94021805	Halichondria panicea	6063	Porifera	other_Eukaryota	80.1	3.88e-15	NR	XP_064389338.1	6063	g23682	i0	63.2	0.564356435643564	57	21	56.4	0	2	172	319	375	XP_064389338.1 alcohol dehydrogenase class-3-like [Halichondria panicea]	diamond	171	80.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
31290808	31290808	PRJNA1005695_P_NODE_42075_length_220_cov_4.659864_g41223_i0	PRJNA1005695	42075	220	4.659864	10.2517008	Metazoa	33208	Porifera	other_Eukaryota	68.9	1.6e-11	NR	XP_065182620.1	27933	g41223	i0	43.3	5.55	67	33	87.3	2	206	15	4289	4353	XP_065182620.1 serine-rich adhesin for platelets-like [Sycon ciliatum]	diamond	1221	69.3	0.994227994227994	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
31481036	31481036	PRJNA1005695_P_NODE_29696_length_274_cov_1.552239_g28844_i0	PRJNA1005695	29696	274	1.552239	4.25313486	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	113	7e-27	NR	XP_065184507.1	27933	g28844	i0	58.8	7.60948905109489	85	35	93.1	0	270	16	512	596	XP_065184507.1 eukaryotic translation initiation factor 3 subunit C-like [Sycon ciliatum]	diamond	2085	113	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32081701	32081701	PRJNA1005695_P_NODE_23298_length_311_cov_2.592437_g22446_i0	PRJNA1005695	23298	311	2.592437	8.06247907	Metazoa	33208	Porifera	other_Eukaryota	58.9	1.02e-7	NR	XP_065843566.1	121494	g22446	i0	47.1	3.39549839228296	70	33	66.6	2	207	1	15	81	XP_065843566.1 START domain-containing protein 10-like [Oscarella lobularis]	diamond	1056	58.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
32564090	32564090	PRJNA1005695_P_NODE_18619_length_350_cov_1.971119_g17767_i0	PRJNA1005695	18619	350	1.971119	6.8989165	Corticium candelabrum	121492	Porifera	other_Eukaryota	86.3	7.44e-17	NR	XP_062509806.1	121492	g17767	i0	43.5	0.985714285714286	115	56	98.6	3	348	4	1887	1992	XP_062509806.1 dedicator of cytokinesis protein 7-like isoform X1 [Corticium candelabrum]	diamond	345	86.3	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);;