metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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
4136775	4136775	PRJNA1160211_S_NODE_231884_length_278_cov_1.404878_g230651_i0	PRJNA1160211	231884	278	1.404878	3.90556084	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	119	2.3699999999999998e-32	NR	XP_011409769.1	400682	g230651	i0	67.4	2.9136690647482	92	30	99.3	0	277	2	21	112	XP_011409769.1 PREDICTED: 40S ribosomal protein S24-like [Amphimedon queenslandica]	diamond	810	119	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
27388278	27388278	PRJNA1160211_S_NODE_274643_length_245_cov_1.790698_g273410_i0	PRJNA1160211	274643	245	1.790698	4.3872101	Oscarella lobularis	121494	Porifera	other_Eukaryota	47.4	8.84e-4	NR	XP_065846603.1	121494	g273410	i0	39.2	1.95918367346939	79	46	96.7	1	237	1	162	238	XP_065846603.1 protein F37C4.5-like [Oscarella lobularis]	diamond	480	47.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
28051135	28051135	PRJNA1160211_S_NODE_39345_length_612_cov_4.948052_g38209_i0	PRJNA1160211	39345	612	4.948052	30.28207824	Halichondria panicea	6063	Porifera	other_Eukaryota	53.1	2.27e-4	NR	XP_064383978.1	6063	g38209	i0	30.9	0.46078431372549	94	61	46.1	2	225	506	16	105	XP_064383978.1 TNF receptor-associated factor 5-like [Halichondria panicea]	diamond	282	53.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30134879	30134879	PRJNA1160211_S_NODE_32152_length_642_cov_3.022847_g31046_i0	PRJNA1160211	32152	642	3.022847	19.40667774	Oopsacas minuta	111878	Porifera	other_Eukaryota	124	1.78e-29	NR	KAI6646008.1	111878	g31046	i0	32	1.90654205607477	200	117	85.5	3	5	553	210	407	KAI6646008.1 hypothetical protein LOD99_13261 [Oopsacas minuta]	diamond	1224	124	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
30754878	30754878	PRJNA1160211_S_NODE_138874_length_391_cov_3.352201_g137641_i0	PRJNA1160211	138874	391	3.352201	13.10710591	Metazoa	33208	Porifera	other_Eukaryota	73.2	1.77e-12	NR	XP_065915441.1	196820	g137641	i0	75.6	1.88746803069054	41	10	31.5	0	164	286	202	242	XP_065915441.1 proteasome subunit beta type-5-like [Dysidea avara]	diamond	738	73.9	0.990527740189445	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
32475023	32475023	PRJNA1160211_S_NODE_217299_length_292_cov_2.397260_g216066_i0	PRJNA1160211	217299	292	2.39726	6.9999992	Geodia barretti	519541	Porifera	other_Eukaryota	53.9	3e-6	NR	CAI8030757.1	519541	g216066	i0	40	2.3527397260274	65	37	66.8	1	282	88	110	172	CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti]	diamond	687	53.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti

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