metadata: contig_metadata: 10 rows where bioproject = "PRJNA721440" and tax

10 rows where bioproject = "PRJNA721440" 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
27252105	27252105	PRJNA721440_S_NODE_11503_length_195_cov_0.931507_g11377_i0	PRJNA721440	11503	195	0.931507	1.81643865	Metazoa	33208	Porifera	other_Eukaryota	46.6	8.53e-4	NR	XP_065835242.1	121494	g11377	i0	43.8	4.27692307692308	48	27	73.8	0	172	29	332	379	XP_065835242.1 uncharacterized protein [Oscarella lobularis]	diamond	834	47	0.991489361702128	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
27410440	27410440	PRJNA721440_S_NODE_3643_length_301_cov_5.464286_g3517_i0	PRJNA721440	3643	301	5.464286	16.44750086	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	2.35e-30	NR	XP_064382987.1	6063	g3517	i0	56.6	69.0697674418605	99	43	98.7	0	2	298	1734	1832	XP_064382987.1 U5 small nuclear ribonucleoprotein 200 kDa helicase-like [Halichondria panicea]	diamond	20790	125	0.992	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28378471	28378471	PRJNA721440_S_NODE_11626_length_194_cov_1.434483_g11500_i0	PRJNA721440	11626	194	1.434483	2.78289702	Dysidea avara	196820	Porifera	other_Eukaryota	54.7	1.17e-6	NR	XP_065913558.1	196820	g11500	i0	56.9	0.788659793814433	51	20	78.9	1	163	11	33	81	XP_065913558.1 uncharacterized protein [Dysidea avara]	diamond	153	54.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
29294161	29294161	PRJNA721440_S_NODE_16009_length_172_cov_2.471545_g15883_i0	PRJNA721440	16009	172	2.471545	4.2510574	Geodia barretti	519541	Porifera	other_Eukaryota	47	4.4e-4	NR	CAI8012763.1	519541	g15883	i0	42.3	0.906976744186046	52	28	90.7	1	158	3	46	95	CAI8012763.1 hypothetical protein GBAR_LOCUS8158 [Geodia barretti]	diamond	156	47	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
30178355	30178355	PRJNA721440_S_NODE_4952_length_267_cov_2.779817_g4826_i0	PRJNA721440	4952	267	2.779817	7.42211139	Halichondria panicea	6063	Porifera	other_Eukaryota	55.5	1.67e-6	NR	XP_064381961.1	6063	g4826	i0	43	3.69662921348315	79	43	87.6	2	240	7	126	203	XP_064381961.1 F-box/LRR-repeat protein fbxl-1-like isoform X1 [Halichondria panicea]	diamond	987	55.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
31157553	31157553	PRJNA721440_S_NODE_21555_length_154_cov_3.142857_g21429_i0	PRJNA721440	21555	154	3.142857	4.83999978	Geodia barretti	519541	Porifera	other_Eukaryota	56.2	1.93e-7	NR	CAI8032194.1	519541	g21429	i0	67.7	1.22727272727273	31	10	60.4	0	5	97	485	515	CAI8032194.1 hypothetical protein GBAR_LOCUS18222 [Geodia barretti]	diamond	189	56.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
31948505	31948505	PRJNA721440_S_NODE_17137_length_168_cov_4.184874_g17011_i0	PRJNA721440	17137	168	4.184874	7.03058832	Halichondria panicea	6063	Porifera	other_Eukaryota	87.4	1.5e-18	NR	XP_064382536.1	6063	g17011	i0	66.7	0.964285714285714	54	18	96.4	0	1	162	198	251	XP_064382536.1 beta-1,3-glucan-binding protein-like [Halichondria panicea]	diamond	162	87.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
32391604	32391604	PRJNA721440_S_NODE_16219_length_171_cov_4.926230_g16093_i0	PRJNA721440	16219	171	4.92623	8.4238533	Corticium candelabrum	121492	Porifera	other_Eukaryota	63.9	4.82e-10	NR	XP_062503430.1	121492	g16093	i0	42.9	0.982456140350877	56	32	98.2	0	171	4	381	436	XP_062503430.1 uncharacterized protein LOC134180315 [Corticium candelabrum]	diamond	168	63.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
32675656	32675656	PRJNA721440_S_NODE_8200_length_220_cov_1.456140_g8074_i0	PRJNA721440	8200	220	1.45614	3.203508	Dysidea avara	196820	Porifera	other_Eukaryota	65.9	1.97e-10	NR	XP_065898754.1	196820	g8074	i0	46.1	1.90909090909091	76	37	98.2	1	2	217	371	446	XP_065898754.1 copine-9-like [Dysidea avara]	diamond	420	65.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
32738969	32738969	PRJNA721440_S_NODE_9840_length_206_cov_2.114650_g9714_i0	PRJNA721440	9840	206	2.11465	4.356179	Sycon ciliatum	27933	Porifera	other_Eukaryota	55.8	5.49e-7	NR	XP_065176545.1	27933	g9714	i0	46.8	0.902912621359223	62	33	90.3	0	3	188	812	873	XP_065176545.1 WD repeat-containing protein 3-like [Sycon ciliatum]	diamond	186	55.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum

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