metadata: contig_metadata: 8 rows where bioproject = "PRJNA1180292", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA1180292", 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
13071525	13071525	PRJNA1180292_P_NODE_7771_length_253_cov_1.300000_g7639_i0	PRJNA1180292	7771	253	1.3	3.289	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	144	1.67e-39	NR	XP_065188764.1	27933	g7639	i0	86.9	7.96837944664032	84	11	99.6	0	2	253	265	348	XP_065188764.1 S-adenosylmethionine synthase-like [Sycon ciliatum]	diamond	2016	144	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
14346895	14346895	PRJNA1180292_P_NODE_2912_length_401_cov_1.185976_g2780_i0	PRJNA1180292	2912	401	1.185976	4.75576376	Dysidea avara	196820	Porifera	other_Eukaryota	54.7	0.011	NTclustered	gi\|2749556513\|ref\|XM_066045316.1\|	196820	g2780	i0	100	0.0723192019950125	29	0	7	0	246	274	1370	1342	PREDICTED: Dysidea avara uncharacterized protein (LOC136252751), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
16894967	16894967	PRJNA1180292_P_NODE_2334_length_445_cov_2.188172_g2202_i0	PRJNA1180292	2334	445	2.188172	9.7373654	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	207	3.0099999999999997e-66	NR	XP_003385490.1	400682	g2202	i0	80.8	23.4808988764045	120	23	80.9	0	86	445	1	120	XP_003385490.1 PREDICTED: 40S ribosomal protein S15a [Amphimedon queenslandica]	diamond	10449	209	0.990430622009569	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
19443853	19443853	PRJNA1180292_P_NODE_3656_length_358_cov_1.143860_g3524_i0	PRJNA1180292	3656	358	1.14386	4.0950188	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	196	2.1099999999999993e-55	NR	XP_064401418.1	6063	g3524	i0	80	9.80446927374302	120	22	98.9	1	2	355	254	373	XP_064401418.1 ATP-citrate synthase-like [Halichondria panicea]	diamond	3510	197	0.99492385786802	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
26597096	26597096	PRJNA1180292_P_NODE_12801_length_242_cov_0.923077_g12669_i0	PRJNA1180292	12801	242	0.923077	2.23384634	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	65.1	4.58e-10	NR	XP_003383462.2	400682	g12669	i0	47.1	1.84710743801653	70	36	85.5	1	238	32	170	239	XP_003383462.2 PREDICTED: gastric triacylglycerol lipase-like [Amphimedon queenslandica]	diamond	447	65.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
26711208	26711208	PRJNA1180292_P_NODE_1321_length_597_cov_3.309160_g1189_i0	PRJNA1180292	1321	597	3.30916	19.7556852	Metazoa	33208	Porifera	other_Eukaryota	195	3.9899999999999997e-60	NR	XP_065831071.1	121494	g1189	i0	76.9	3.90954773869347	130	30	65.3	0	427	38	31	160	XP_065831071.1 large ribosomal subunit protein uL23-like [Oscarella lobularis]	diamond	2334	195	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
27185984	27185984	PRJNA1180292_P_NODE_2402_length_439_cov_1.245902_g2270_i0	PRJNA1180292	2402	439	1.245902	5.46950978	Metazoa	33208	Porifera	other_Eukaryota	134	1e-34	NR	XP_065886114.1	196820	g2270	i0	59.1	1.74259681093394	127	52	86.8	0	383	3	1	127	XP_065886114.1 uncharacterized protein [Dysidea avara]	diamond	765	134	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
32821839	32821839	PRJNA1180292_P_NODE_6260_length_281_cov_1.120192_g6128_i0	PRJNA1180292	6260	281	1.120192	3.14773952	Oscarella lobularis	121494	Porifera	other_Eukaryota	123	2.15e-30	NR	XP_065845122.1	121494	g6128	i0	57.4	3.95017793594306	94	38	99.3	2	281	3	209	301	XP_065845122.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 1-like [Oscarella lobularis]	diamond	1110	123	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis

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