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

8 rows where bioproject = "PRJNA534016", 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
507490	507490	PRJNA534016_P_NODE_14081_length_250_cov_0.870056_g13991_i0	PRJNA534016	14081	250	0.870056	2.17514	Poecillastra laminaris	1336882	Porifera	other_Eukaryota	106	1.71e-18	NTclustered	gi\|699257052\|ref\|NC_025335.1\|	1336882	g13991	i0	92	12.296	75	6	30	0	100	174	156	230	Poecillastra laminaris mitochondrion, complete genome	blastn	3074	106	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Vulcanellidae	Poecillastra	Poecillastra laminaris
18359004	18359004	PRJNA534016_P_NODE_16595_length_245_cov_0.895349_g16505_i0	PRJNA534016	16595	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	58.2	1.41e-7	NR	XP_065919832.1	196820	g16505	i0	45.7	2.95102040816327	81	39	96.7	3	1	237	442	519	XP_065919832.1 hepatocyte growth factor receptor-like [Dysidea avara]	diamond	723	58.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
22795462	22795462	PRJNA534016_P_NODE_19038_length_229_cov_2.429487_g18948_i0	PRJNA534016	19038	229	2.429487	5.56352523	Metazoa	33208	Porifera	other_Eukaryota	52.8	0.02	NTclustered	gi\|2732933519\|ref\|XM_065333841.1\|	27933	g18948	i0	100	0.733624454148472	28	0	12	0	112	139	2194	2167	PREDICTED: Sycon ciliatum uncharacterized LOC135820797 (LOC135820797), mRNA	blastn	168	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
27945593	27945593	PRJNA534016_P_NODE_12105_length_262_cov_2.910053_g12015_i0	PRJNA534016	12105	262	2.910053	7.62433886	Opisthokonta	33154	Porifera	other_Eukaryota	73.9	4.94e-13	NR	KAI6652829.1	111878	g12015	i0	43	9.11450381679389	79	43	88.2	2	31	261	466	544	KAI6652829.1 Histone-lysine N-methyltransferase EZH2 [Oopsacas minuta]	diamond	2388	73.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
28324356	28324356	PRJNA534016_P_NODE_8826_length_288_cov_2.060465_g8736_i0	PRJNA534016	8826	288	2.060465	5.9341392	Opisthokonta	33154	Porifera	other_Eukaryota	52.8	1.86e-5	NR	XP_065179382.1	27933	g8736	i0	40.9	3.64583333333333	66	38	67.7	1	254	60	524	589	XP_065179382.1 acyl-CoA dehydrogenase family member 11-like [Sycon ciliatum]	diamond	1050	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
28450902	28450902	PRJNA534016_P_NODE_9586_length_282_cov_1.842105_g9496_i0	PRJNA534016	9586	282	1.842105	5.1947361	Porifera	6040	Porifera	other_Eukaryota	57.4	3.77e-8	NR	XP_065184934.1	27933	g9496	i0	57.8	0.968085106382979	45	19	47.9	0	281	147	27	71	XP_065184934.1 uncharacterized protein LOC135815548 [Sycon ciliatum]	diamond	273	57.8	0.993079584775087	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
31483438	31483438	PRJNA534016_P_NODE_1256_length_735_cov_1.145015_g1172_i0	PRJNA534016	1256	735	1.145015	8.41586025	Metazoa	33208	Porifera	other_Eukaryota	279	1.7999999999999997e-88	NR	AQM52339.1	121494	g1172	i0	56.4	27.7142857142857	241	93	96.3	3	24	731	212	445	AQM52339.1 elongation factor 1 alpha, partial [Oscarella lobularis]	diamond	20370	279	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
31531703	31531703	PRJNA534016_P_NODE_13056_length_255_cov_1.637363_g12966_i0	PRJNA534016	13056	255	1.637363	4.17527565	Dysidea avara	196820	Porifera	other_Eukaryota	42.7	0.0301	NR	XP_065885570.1	196820	g12966	i0	37.7	0.811764705882353	69	38	75.3	2	236	45	6	74	XP_065885570.1 high mobility group protein B2-like [Dysidea avara]	diamond	207	42.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara

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