metadata: contig_metadata: 10 rows where bioproject = "PRJNA917598", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA917598", 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
26771470	26771470	PRJNA917598_P_NODE_89221_length_245_cov_0.895349_g88277_i0	PRJNA917598	89221	245	0.895349	2.19360505	Geodia barretti	519541	Porifera	other_Eukaryota	100	1.42e-22	NR	CAI8017777.1	519541	g88277	i0	63	2.97551020408163	81	27	99.2	2	245	3	285	362	CAI8017777.1 Alpha-glucosidase, partial [Geodia barretti]	diamond	729	100	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
26961153	26961153	PRJNA917598_P_NODE_76762_length_257_cov_1.543478_g75818_i0	PRJNA917598	76762	257	1.543478	3.96673846	Oscarella lobularis	121494	Porifera	other_Eukaryota	100	1.3899999999999998e-23	NR	XP_065836436.1	121494	g75818	i0	64.7	3.94552529182879	85	28	99.2	1	257	3	115	197	XP_065836436.1 small ribosomal subunit protein eS6-like [Oscarella lobularis]	diamond	1014	100	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
27877502	27877502	PRJNA917598_P_NODE_66925_length_278_cov_1.365854_g65981_i0	PRJNA917598	66925	278	1.365854	3.79707412	Suberites domuncula	55567	Porifera	other_Eukaryota	69.7	1.29e-11	NR	Q4KTE2.1	55567	g65981	i0	44.6	0.992805755395683	92	47	98.2	3	3	275	173	261	Q4KTE2.1 RecName: Full=Small ribosomal subunit protein uS2; AltName: Full=40S ribosomal protein SA [Suberites domuncula]	diamond	276	69.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
28737341	28737341	PRJNA917598_P_NODE_60447_length_290_cov_1.405530_g59503_i0	PRJNA917598	60447	290	1.40553	4.076037	root	1	Root_unresolved	Root_unresolved	71.2	6.06e-12	NR	XP_062522437.1	121492	g59503	i0	47.9	2.12068965517241	73	36	73.4	1	213	1	194	266	XP_062522437.1 phospholipase B-like [Corticium candelabrum]	diamond	615	71.6	0.994413407821229	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
28824477	28824477	PRJNA917598_P_NODE_71248_length_269_cov_1.571429_g70304_i0	PRJNA917598	71248	269	1.571429	4.22714401	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	136	8.53e-39	NR	XP_003382502.1	400682	g70304	i0	75.3	9.92565055762082	89	22	99.3	0	1	267	33	121	XP_003382502.1 PREDICTED: 60S ribosomal protein L12-like [Amphimedon queenslandica]	diamond	2670	136	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
29298343	29298343	PRJNA917598_P_NODE_23609_length_477_cov_1.155941_g22667_i0	PRJNA917598	23609	477	1.155941	5.51383857	Hymeniacidon perlevis	177573	Porifera	other_Eukaryota	186	3.49e-57	NR	ABO26247.1	177573	g22667	i0	63.1	2.05031446540881	160	56	100	2	477	1	6	163	ABO26247.1 14-3-3 K, partial [Hymeniacidon perlevis]	diamond	978	186	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Hymeniacidon	Hymeniacidon perlevis
29463118	29463118	PRJNA917598_P_NODE_79690_length_251_cov_0.865169_g78746_i0	PRJNA917598	79690	251	0.865169	2.17157419	Metazoa	33208	Porifera	other_Eukaryota	116	4.46e-28	NR	CAI8029620.1	519541	g78746	i0	68.3	1.9601593625498	82	26	98	0	247	2	146	227	CAI8029620.1 Lysine--tRNA ligase [Geodia barretti]	diamond	492	117	0.991452991452991	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
30182571	30182571	PRJNA917598_P_NODE_76712_length_257_cov_1.673913_g75768_i0	PRJNA917598	76712	257	1.673913	4.30195641	Oscarella lobularis	121494	Porifera	other_Eukaryota	73.2	8.6e-13	NR	XP_065844907.1	121494	g75768	i0	62	1.52918287937743	50	19	58.4	0	255	106	705	754	XP_065844907.1 uncharacterized protein [Oscarella lobularis]	diamond	393	73.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
31415079	31415079	PRJNA917598_P_NODE_60656_length_290_cov_1.115207_g59712_i0	PRJNA917598	60656	290	1.115207	3.2341003	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	73.9	1.31e-13	NR	XP_003384181.1	400682	g59712	i0	38.8	1.01379310344828	98	55	99.3	2	2	289	85	179	XP_003384181.1 PREDICTED: probable GH family 25 lysozyme 2 [Amphimedon queenslandica]	diamond	294	73.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
31928426	31928426	PRJNA917598_P_NODE_91537_length_244_cov_0.900585_g90593_i0	PRJNA917598	91537	244	0.900585	2.1974274	Demospongiae	6042	Porifera	other_Eukaryota	53.5	6.07e-6	NR	ALB75312.1	6052	g90593	i0	38.6	2.69262295081967	70	42	84.8	1	238	32	882	951	ALB75312.1 dishevelled-associated activator of morphogenesis [Ephydatia muelleri]	diamond	657	53.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Spongillida	Spongillidae	Ephydatia	Ephydatia muelleri

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