metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA448207" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA448207" 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
23391118	23391118	PRJNA448207_P_NODE_5339_length_521_cov_0.950893_g5180_i0	PRJNA448207	5339	521	0.950893	4.95415253	Metazoa	33208	Porifera	other_Eukaryota	224	5.04e-66	NR	XP_064382801.1	6063	g5180	i0	60.7	16.8829174664107	173	68	99.6	0	3	521	483	655	XP_064382801.1 prolyl endopeptidase-like [Halichondria panicea]	diamond	8796	226	0.991150442477876	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
27928928	27928928	PRJNA448207_P_NODE_32205_length_242_cov_0.911243_g32042_i0	PRJNA448207	32205	242	0.911243	2.20520806	Dysidea avara	196820	Porifera	other_Eukaryota	61.2	1.1e-8	NR	XP_065892787.1	196820	g32042	i0	56.9	0.632231404958678	51	22	63.2	0	229	77	179	229	XP_065892787.1 E3 SUMO-protein ligase ZBED1-like [Dysidea avara]	diamond	153	61.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
28608226	28608226	PRJNA448207_P_NODE_25507_length_251_cov_0.865169_g25344_i0	PRJNA448207	25507	251	0.865169	2.17157419	Metazoa	33208	Porifera	other_Eukaryota	59.7	3.35e-8	NR	XP_062517169.1	121492	g25344	i0	51.7	5.55776892430279	58	20	59.8	2	2	151	111	168	XP_062517169.1 adhesion G protein-coupled receptor B3-like, partial [Corticium candelabrum]	diamond	1395	60.1	0.993344425956739	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
29081927	29081927	PRJNA448207_S_NODE_3988_length_241_cov_1.375000_g3977_i0	PRJNA448207	3988	241	1.375	3.31375	Opisthokonta	33154	Porifera	other_Eukaryota	81.3	5.98e-16	NR	XP_064404848.1	6063	g3977	i0	48.8	16.9294605809129	80	41	99.6	0	1	240	250	329	XP_064404848.1 replication factor C subunit 3-like [Halichondria panicea]	diamond	4080	81.6	0.996323529411765	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
29570634	29570634	PRJNA448207_S_NODE_3130_length_261_cov_0.824468_g3119_i0	PRJNA448207	3130	261	0.824468	2.15186148	Halisarca dujardinii	2583056	Porifera	other_Eukaryota	123	5.25e-32	NR	QSX72227.1	2583056	g3119	i0	65.9	0.942528735632184	82	28	94.3	0	259	14	240	321	QSX72227.1 glutaredoxin 3 [Halisarca dujardinii]	diamond	246	123	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Chondrillida	Halisarcidae	Halisarca	Halisarca dujardinii
30360896	30360896	PRJNA448207_S_NODE_3332_length_253_cov_1.655556_g3321_i0	PRJNA448207	3332	253	1.655556	4.18855668	Halichondria panicea	6063	Porifera	other_Eukaryota	80.5	1.53e-15	NR	XP_064389338.1	6063	g3321	i0	63.2	0.675889328063241	57	21	67.6	0	2	172	319	375	XP_064389338.1 alcohol dehydrogenase class-3-like [Halichondria panicea]	diamond	171	80.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
31561609	31561609	PRJNA448207_P_NODE_11056_length_374_cov_1.259136_g10894_i0	PRJNA448207	11056	374	1.259136	4.70916864	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	52.4	6.5e-5	NR	XP_019864453.1	400682	g10894	i0	34.3	1.60427807486631	108	69	86.6	1	5	328	248	353	XP_019864453.1 PREDICTED: dnaJ homolog subfamily C member 2-like [Amphimedon queenslandica]	diamond	600	52.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
32067459	32067459	PRJNA448207_P_NODE_24538_length_256_cov_1.262295_g24375_i0	PRJNA448207	24538	256	1.262295	3.2314752	Oopsacas minuta	111878	Porifera	other_Eukaryota	79.3	5.61e-15	NR	KAI6646603.1	111878	g24375	i0	48.8	1.0078125	86	43	99.6	1	256	2	179	264	KAI6646603.1 DDB1- and CUL4-associated factor 8-like [Oopsacas minuta]	diamond	258	79.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
32289454	32289454	PRJNA448207_P_NODE_6219_length_485_cov_0.837379_g6057_i0	PRJNA448207	6219	485	0.837379	4.06128815	Sycon ciliatum	27933	Porifera	other_Eukaryota	79	1.11e-13	NR	XP_065176355.1	27933	g6057	i0	58.3	2.23917525773196	60	25	37.1	0	273	452	65	124	XP_065176355.1 serine/threonine-protein phosphatase 2A 56 kDa regulatory subunit gamma isoform-like [Sycon ciliatum]	diamond	1086	79	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);;