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

9 rows where analysis = "diamond", bioproject = "PRJNA700095" 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
27746349	27746349	PRJNA700095_P_NODE_23104_length_361_cov_1.059028_g21840_i0	PRJNA700095	23104	361	1.059028	3.82309108	Halichondria panicea	6063	Porifera	other_Eukaryota	44.7	0.0303	NR	XP_064401495.1	6063	g21840	i0	38.6	0.947368421052632	57	30	47.4	1	306	136	947	998	XP_064401495.1 ubiquitin carboxyl-terminal hydrolase 40-like [Halichondria panicea]	diamond	342	44.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28219509	28219509	PRJNA700095_P_NODE_56886_length_247_cov_0.879310_g55622_i0	PRJNA700095	56886	247	0.87931	2.1718957	Dysidea avara	196820	Porifera	other_Eukaryota	52	1.92e-5	NR	XP_065906761.1	196820	g55622	i0	42.6	0.740890688259109	61	27	74.1	1	185	3	238	290	XP_065906761.1 alanine--tRNA ligase-like [Dysidea avara]	diamond	183	52	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
29324749	29324749	PRJNA700095_P_NODE_29669_length_312_cov_1.246862_g28405_i0	PRJNA700095	29669	312	1.246862	3.89020944	Dysidea avara	196820	Porifera	other_Eukaryota	79.7	6.37e-16	NR	XP_065900303.1	196820	g28405	i0	38.1	1.875	105	62	99	2	311	3	84	187	XP_065900303.1 apolipoprotein D-like isoform X2 [Dysidea avara]	diamond	585	79.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
29682985	29682985	PRJNA700095_P_NODE_19450_length_402_cov_2.574468_g18187_i0	PRJNA700095	19450	402	2.574468	10.34936136	Porifera	6040	Porifera	other_Eukaryota	97.8	2.17e-22	NR	XP_065185469.1	27933	g18187	i0	44	1.75373134328358	100	56	74.6	0	102	401	90	189	XP_065185469.1 COMM domain-containing protein 9-like [Sycon ciliatum]	diamond	705	98.6	0.991886409736308	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
29893366	29893366	PRJNA700095_P_NODE_16771_length_443_cov_2.300000_g15508_i0	PRJNA700095	16771	443	2.3	10.189	Sycon ciliatum	27933	Porifera	other_Eukaryota	148	2.52e-40	NR	XP_065175618.1	27933	g15508	i0	52.3	5.08577878103837	128	61	86.7	0	387	4	29	156	XP_065175618.1 tartrate-resistant acid phosphatase type 5-like [Sycon ciliatum]	diamond	2253	148	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
30872613	30872613	PRJNA700095_P_NODE_6534_length_776_cov_3.237553_g5448_i0	PRJNA700095	6534	776	3.237553	25.12341128	Oscarella lobularis	121494	Porifera	other_Eukaryota	239	4.24e-71	NR	XP_065826338.1	121494	g5448	i0	48.4	2.53994845360825	223	105	86.2	2	704	36	37	249	XP_065826338.1 alpha-glucosidase 2-like isoform X2 [Oscarella lobularis]	diamond	1971	239	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
31062468	31062468	PRJNA700095_P_NODE_45035_length_264_cov_1.193717_g43771_i0	PRJNA700095	45035	264	1.193717	3.15141288	Geodia barretti	519541	Porifera	other_Eukaryota	62.4	2.92e-9	NR	CAI8028384.1	519541	g43771	i0	45.5	1.75	77	34	86.4	2	33	260	101	170	CAI8028384.1 Serine/threonine-protein phosphatase PGAM5, mitochondrial, partial [Geodia barretti]	diamond	462	62.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
31188242	31188242	PRJNA700095_P_NODE_30535_length_309_cov_2.677966_g29271_i0	PRJNA700095	30535	309	2.677966	8.27491494	Corticium candelabrum	121492	Porifera	other_Eukaryota	84	2.72e-16	NR	XP_062514930.1	121492	g29271	i0	41.2	3.89320388349515	102	60	99	0	308	3	612	713	XP_062514930.1 pre-mRNA-splicing factor SYF1-like [Corticium candelabrum]	diamond	1203	84	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
32232768	32232768	PRJNA700095_P_NODE_53358_length_249_cov_1.437500_g52094_i0	PRJNA700095	53358	249	1.4375	3.579375	Dysidea avara	196820	Porifera	other_Eukaryota	68.9	2.16e-11	NR	XP_065910755.1	196820	g52094	i0	47.1	0.843373493975904	70	33	84.3	1	211	2	23	88	XP_065910755.1 arginine kinase Lit v 2-like [Dysidea avara]	diamond	210	68.9	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);;