metadata: contig_metadata: 11 rows where bioproject = "PRJNA725806", tax_kingdom = "Metazoa" and tax

11 rows where bioproject = "PRJNA725806", 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
13465673	13465673	PRJNA725806_P_NODE_45591_length_255_cov_9.513761_g45294_i0	PRJNA725806	45591	255	9.513761	24.26009055	Dysidea avara	196820	Porifera	other_Eukaryota	65.8	2.98e-6	NTclustered	gi\|2749510091\|ref\|XM_066063570.1\|	196820	g45294	i0	90.196	0.4	51	4	20	1	158	207	853	803	PREDICTED: Dysidea avara pyridoxal phosphate homeostasis protein-like (LOC136268282), mRNA	blastn	102	65.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
27883816	27883816	PRJNA725806_P_NODE_135305_length_176_cov_1.338129_g135003_i0	PRJNA725806	135305	176	1.338129	2.35510704	root	1	Root_unresolved	Root_unresolved	43.5	0.00564	NR	CAI8037434.1	519541	g135003	i0	67.9	8.33522727272727	28	9	47.7	0	86	3	29	56	CAI8037434.1 LINE-1 retrotransposable element ORF2 protein [Geodia barretti]	diamond	1467	43.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
28442033	28442033	PRJNA725806_P_NODE_19246_length_321_cov_1.369718_g18952_i0	PRJNA725806	19246	321	1.369718	4.39679478	Halichondria panicea	6063	Porifera	other_Eukaryota	67.4	2.08e-10	NR	XP_064386056.1	6063	g18952	i0	43.5	1.70093457943925	92	44	85	4	42	314	302	386	XP_064386056.1 uncharacterized protein LOC135334699 isoform X2 [Halichondria panicea]	diamond	546	67.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28610095	28610095	PRJNA725806_P_NODE_115887_length_186_cov_12.885906_g115585_i0	PRJNA725806	115887	186	12.885906	23.96778516	Metazoa	33208	Porifera	other_Eukaryota	56.2	3.01e-7	NR	XP_065902300.1	196820	g115585	i0	46	3.03225806451613	50	27	80.6	0	17	166	1023	1072	XP_065902300.1 uncharacterized protein [Dysidea avara]	diamond	564	56.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
28820427	28820427	PRJNA725806_P_NODE_160108_length_164_cov_2.299213_g159806_i0	PRJNA725806	160108	164	2.299213	3.77070932	Oscarella lobularis	121494	Porifera	other_Eukaryota	55.1	5.22e-7	NR	XP_065836357.1	121494	g159806	i0	71.9	2.63414634146341	32	9	58.5	0	117	22	183	214	XP_065836357.1 traB domain-containing protein-like [Oscarella lobularis]	diamond	432	55.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
29588546	29588546	PRJNA725806_P_NODE_125230_length_181_cov_3.611111_g124928_i0	PRJNA725806	125230	181	3.611111	6.53611091	Metazoa	33208	Porifera	other_Eukaryota	43.9	0.00649	NR	XP_003391456.1	400682	g124928	i0	55.8	7.16022099447514	43	18	71.3	1	133	5	28	69	XP_003391456.1 PREDICTED: jerky protein homolog-like [Amphimedon queenslandica]	diamond	1296	43.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
30157153	30157153	PRJNA725806_P_NODE_66192_length_227_cov_6.773684_g65892_i0	PRJNA725806	66192	227	6.773684	15.37626268	Metazoa	33208	Porifera	other_Eukaryota	43.1	0.0227	NR	XP_065837894.1	121494	g65892	i0	77.3	2.96035242290749	22	5	29.1	0	11	76	334	355	XP_065837894.1 uncharacterized protein [Oscarella lobularis]	diamond	672	43.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
30178550	30178550	PRJNA725806_P_NODE_186652_length_153_cov_3.862069_g186350_i0	PRJNA725806	186652	153	3.862069	5.90896557	Corticium candelabrum	121492	Porifera	other_Eukaryota	70.5	3.06e-13	NR	XP_062515212.1	121492	g186350	i0	67.3	1.80392156862745	49	16	96.1	0	148	2	122	170	XP_062515212.1 protein-S-isoprenylcysteine O-methyltransferase-like [Corticium candelabrum]	diamond	276	70.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
30715692	30715692	PRJNA725806_P_NODE_20334_length_316_cov_4.849462_g20038_i0	PRJNA725806	20334	316	4.849462	15.32429992	Sycon ciliatum	27933	Porifera	other_Eukaryota	43.5	0.0493	NR	XP_065195949.1	27933	g20038	i0	44.1	0.322784810126582	34	19	32.3	0	102	1	469	502	XP_065195949.1 uncharacterized protein LOC135827368 [Sycon ciliatum]	diamond	102	43.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
31168160	31168160	PRJNA725806_P_NODE_172495_length_159_cov_1.270492_g172193_i0	PRJNA725806	172495	159	1.270492	2.02008228	Metazoa	33208	Porifera	other_Eukaryota	66.2	5.33e-11	NR	XP_064403340.1	6063	g172193	i0	88.9	44.7169811320755	36	4	67.9	0	109	2	93	128	XP_064403340.1 DNA repair protein RAD51 homolog A [Halichondria panicea]	diamond	7110	66.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
32402262	32402262	PRJNA725806_P_NODE_175159_length_158_cov_0.950413_g174857_i0	PRJNA725806	175159	158	0.950413	1.50165254	Metazoa	33208	Porifera	other_Eukaryota	48.9	7.8e-5	NR	AZI95706.1	6063	g174857	i0	100	147.645569620253	24	0	45.6	0	87	158	297	320	AZI95706.1 valosin containing protein, partial [Halichondria panicea]	diamond	23328	48.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea

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