metadata: contig_metadata: 10 rows where bioproject = "PRJEB3181", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJEB3181", tax_clade = "Opisthokonta" 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
56042	56042	PRJEB3181_P_NODE_5621_length_345_cov_3.000000_g5367_i0	PRJEB3181	5621	345	3	10.35	Geodia barretti	519541	Porifera	other_Eukaryota	147	4.829999999999999e-42	NR	CAI8032315.1	519541	g5367	i0	73.7	0.826086956521739	95	25	82.6	0	1	285	41	135	CAI8032315.1 40S ribosomal protein S8 [Geodia barretti]	diamond	285	147	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
1330304	1330304	PRJEB3181_P_NODE_762_length_646_cov_33.221138_g18_i4	PRJEB3181	762	646	33.221138	214.60855148	Soleneiscus stolonifer	365352	Porifera	other_Eukaryota	333	2.0500000000000006e-86	NTclustered	gi\|111606966\|emb\|AM180983.1\|	365352	g18	i4	78.625	76.2569659442725	538	89	82	22	18	548	585	1103	Soleneiscus stolonifer partial 28S rRNA gene, specimen voucher G313668 (Queensland Museum)	blastn	49262	333	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Clathrinida	Dendyidae	Soleneiscus	Soleneiscus stolonifer
7366404	7366404	PRJEB3181_P_NODE_19326_length_187_cov_7.762821_g19062_i0	PRJEB3181	19326	187	7.762821	14.51647527	Metazoa	33208	Porifera	other_Eukaryota	99	2.03e-16	NTclustered	gi\|1284883228\|gb\|KY825184.1\|	178514	g19062	i0	79.452	12.9197860962567	146	24	77	4	42	185	3474	3333	Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence	blastn	2416	99	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon compressa
10258723	10258723	PRJEB3181_P_NODE_3269_length_417_cov_8.129534_g3036_i0	PRJEB3181	3269	417	8.129534	33.90015678	Geodia barretti	519541	Porifera	other_Eukaryota	164	9.63e-47	NR	CAI8026159.1	519541	g3036	i0	65.1	1.57553956834532	109	36	77	1	401	81	215	323	CAI8026159.1 Cathepsin B [Geodia barretti]	diamond	657	164	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
12809635	12809635	PRJEB3181_S_NODE_2371_length_350_cov_317.555556_g2078_i0	PRJEB3181	2371	350	317.555556	1111.444446	Opisthokonta	33154	Porifera	other_Eukaryota	64.3	1.74e-10	NR	AAX48897.1	55567	g2078	i0	65.1	3.98571428571429	43	15	36.9	0	2	130	75	117	AAX48897.1 S20 [Suberites domuncula]	diamond	1395	64.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
14084346	14084346	PRJEB3181_S_NODE_1392_length_417_cov_8.437173_g1106_i0	PRJEB3181	1392	417	8.437173	35.18301141	Mycale sp. GLH-2013	1325611	Porifera	other_Eukaryota	191	8.15e-44	NTclustered	gi\|514227079\|gb\|KC961659.1\|	1325611	g1106	i0	89.474	19.0599520383693	152	14	36	2	8	158	97	247	Mycale sp. GLH-2013 voucher MNRJ15636 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	7948	191	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Poecilosclerida	Mycalidae	Mycale	Mycale sp. GLH-2013
18840559	18840559	PRJEB3181_S_NODE_4055_length_292_cov_18.704280_g3762_i0	PRJEB3181	4055	292	18.70428	54.6164976	Metazoa	33208	Porifera	other_Eukaryota	99	3.43e-16	NTclustered	gi\|1284883228\|gb\|KY825184.1\|	178514	g3762	i0	79.452	10.2123287671233	146	24	49	4	131	274	3474	3333	Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence	blastn	2982	99	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon compressa
27791563	27791563	PRJEB3181_P_NODE_4664_length_370_cov_4.386431_g4416_i0	PRJEB3181	4664	370	4.386431	16.2297947	Sycon ciliatum	27933	Porifera	other_Eukaryota	97.1	1.75e-22	NR	XP_065177154.1	27933	g4416	i0	60	1.2972972972973	80	32	64.9	0	370	131	100	179	XP_065177154.1 peroxiredoxin-5, mitochondrial-like [Sycon ciliatum]	diamond	480	97.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
32049816	32049816	PRJEB3181_P_NODE_18758_length_191_cov_1.318750_g18494_i0	PRJEB3181	18758	191	1.31875	2.5188125	root	1	Root_unresolved	Root_unresolved	63.2	1.05e-9	NR	XP_019857249.1	400682	g18494	i0	57.8	1.3979057591623	45	15	64.4	1	186	64	296	340	XP_019857249.1 PREDICTED: cathepsin O-like [Amphimedon queenslandica]	diamond	267	63.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
32056371	32056371	PRJEB3181_P_NODE_10278_length_265_cov_1.717949_g10014_i0	PRJEB3181	10278	265	1.717949	4.55256485	Oopsacas minuta	111878	Porifera	other_Eukaryota	95.1	7.969999999999999e-23	NR	KAI6654715.1	111878	g10014	i0	64.7	6.16981132075472	68	24	77	0	257	54	54	121	KAI6654715.1 Ribosomal protein L32 [Oopsacas minuta]	diamond	1635	95.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta

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