metadata: contig_metadata: 11 rows where bioproject = "PRJNA934332", tax_clade = "Opisthokonta" and tax

11 rows where bioproject = "PRJNA934332", tax_clade = "Opisthokonta" 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
9838605	9838605	PRJNA934332_P_NODE_5548_length_285_cov_1.216981_g5461_i0	PRJNA934332	5548	285	1.216981	3.46839585	Geodia barretti	519541	Porifera	other_Eukaryota	116	7.32e-28	NR	CAI8054064.1	519541	g5461	i0	53.3	0.947368421052632	90	42	94.7	0	284	15	400	489	CAI8054064.1 Alpha-N-acetylglucosaminidase [Geodia barretti]	diamond	270	116	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
14938540	14938540	PRJNA934332_P_NODE_712_length_708_cov_1.409449_g632_i0	PRJNA934332	712	708	1.409449	9.97889892	root	1	Root_unresolved	Root_unresolved	246	1.37e-76	NR	XP_062512848.1	121492	g632	i0	60	2.89406779661017	225	85	95.3	1	23	697	181	400	XP_062512848.1 uncharacterized protein LOC134188698 [Corticium candelabrum]	diamond	2049	247	0.995951417004049	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
27972565	27972565	PRJNA934332_P_NODE_4565_length_309_cov_1.305085_g4478_i0	PRJNA934332	4565	309	1.305085	4.03271265	Halichondria panicea	6063	Porifera	other_Eukaryota	90.1	1.63e-18	NR	XP_064403689.1	6063	g4478	i0	47.3	1.80582524271845	91	43	88.3	2	302	30	298	383	XP_064403689.1 endoglycoceramidase-like [Halichondria panicea]	diamond	558	90.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28446316	28446316	PRJNA934332_P_NODE_3286_length_353_cov_0.939286_g3199_i0	PRJNA934332	3286	353	0.939286	3.31567958	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	100	2.4099999999999994e-23	NR	XP_003391149.1	400682	g3199	i0	53.3	1.52974504249292	90	42	76.5	0	271	2	28	117	XP_003391149.1 PREDICTED: pyruvate dehydrogenase E1 component subunit alpha, somatic form, mitochondrial-like, partial [Amphimedon queenslandica]	diamond	540	100	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
28895126	28895126	PRJNA934332_P_NODE_10128_length_244_cov_0.900585_g10041_i0	PRJNA934332	10128	244	0.900585	2.1974274	Metazoa	33208	Porifera	other_Eukaryota	127	5.32e-35	NR	XP_064392692.1	6063	g10041	i0	70.9	4.80737704918033	79	23	97.1	0	6	242	21	99	XP_064392692.1 vacuolar protein sorting-associated protein 29-like [Halichondria panicea]	diamond	1173	127	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
29393507	29393507	PRJNA934332_P_NODE_1789_length_456_cov_1.245431_g1702_i0	PRJNA934332	1789	456	1.245431	5.67916536	Oscarella lobularis	121494	Porifera	other_Eukaryota	66.6	1.51e-9	NR	XP_065842901.1	121494	g1702	i0	65.9	0.269736842105263	41	14	27	0	445	323	368	408	XP_065842901.1 ornithine decarboxylase-like isoform X2 [Oscarella lobularis]	diamond	123	66.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
30309828	30309828	PRJNA934332_P_NODE_10832_length_242_cov_0.911243_g10745_i0	PRJNA934332	10832	242	0.911243	2.20520806	Corticium candelabrum	121492	Porifera	other_Eukaryota	58.5	9.49e-8	NR	XP_062500861.1	121492	g10745	i0	37.9	1.17768595041322	95	44	99.2	3	242	3	91	185	XP_062500861.1 phospholipase A2 group XV-like [Corticium candelabrum]	diamond	285	58.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
30719984	30719984	PRJNA934332_P_NODE_7234_length_255_cov_1.692308_g7147_i0	PRJNA934332	7234	255	1.692308	4.3153854	Halichondria panicea	6063	Porifera	other_Eukaryota	89	2.4e-18	NR	XP_064395912.1	6063	g7147	i0	49.4	3.75294117647059	79	40	92.9	0	19	255	89	167	XP_064395912.1 uncharacterized protein LOC135342948 isoform X2 [Halichondria panicea]	diamond	957	89	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
31422424	31422424	PRJNA934332_P_NODE_1036_length_591_cov_1.588803_g952_i0	PRJNA934332	1036	591	1.588803	9.38982573	Porifera	6040	Porifera	other_Eukaryota	174	8.769999999999999e-52	NR	XP_062508348.1	121492	g952	i0	70.9	6.47715736040609	127	37	64.5	0	400	20	36	162	XP_062508348.1 large ribosomal subunit protein uL23-like [Corticium candelabrum]	diamond	3828	175	0.994285714285714	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
31478857	31478857	PRJNA934332_P_NODE_10016_length_244_cov_1.350877_g9929_i0	PRJNA934332	10016	244	1.350877	3.29613988	Halichondria panicea	6063	Porifera	other_Eukaryota	55.5	1.22e-6	NR	XP_064383104.1	6063	g9929	i0	43.8	0.786885245901639	64	34	76.2	1	59	244	354	417	XP_064383104.1 FAS-associated factor 2-like [Halichondria panicea]	diamond	192	55.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
32806239	32806239	PRJNA934332_P_NODE_2280_length_411_cov_1.366864_g2193_i0	PRJNA934332	2280	411	1.366864	5.61781104	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	91.3	2.6e-18	NR	XP_011402819.2	400682	g2193	i0	46.2	0.773722627737226	106	53	75.9	2	408	97	352	455	XP_011402819.2 PREDICTED: filamin-C-like [Amphimedon queenslandica]	diamond	318	91.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica

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