metadata: contig_metadata: 5 rows where bioproject = "PRJEB20058", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJEB20058", 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
25612540	25612540	PRJEB20058_P_NODE_14361_length_1095_cov_4.622824_g12597_i0	PRJEB20058	14361	1095	4.622824	50.6199228	Metazoa	33208	Porifera	other_Eukaryota	185	1.0499999999999998e-41	NTclustered	gi\|512765252\|gb\|KC869490.1\|	458489	g12597	i0	80.816	14.1260273972603	245	39	22	8	558	801	1069	1306	Cinachyrella kuekenthali voucher P23 28S ribosomal RNA gene, partial sequence	blastn	15468	185	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Tetillidae	Cinachyrella	Cinachyrella kuekenthali
25749477	25749477	PRJEB20058_P_NODE_187578_length_267_cov_26.194175_g184755_i0	PRJEB20058	187578	267	26.194175	69.93844725	Leucettidae	81544	Porifera	other_Eukaryota	237	6.28e-58	NTclustered	gi\|385158759\|gb\|JQ272297.1\|	197028	g184755	i0	84.553	81.0224719101124	246	31	91	7	25	267	2723	2482	Leucetta microraphis voucher QM G313659 28S ribosomal RNA gene, partial sequence	blastn	21633	237	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Clathrinida	Leucettidae	Leucetta	Leucetta microraphis
26062209	26062209	PRJEB20058_P_NODE_222397_length_241_cov_1.422222_g219572_i0	PRJEB20058	222397	241	1.422222	3.42755502	Dysidea avara	196820	Porifera	other_Eukaryota	52.8	0.022	NTclustered	gi\|2749503576\|ref\|XM_066048906.1\|	196820	g219572	i0	96.774	0.128630705394191	31	1	13	0	98	128	576	546	PREDICTED: Dysidea avara enolase-phosphatase E1-like (LOC136255996), mRNA	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
26193697	26193697	PRJEB20058_P_NODE_109934_length_385_cov_2.709877_g107123_i0	PRJEB20058	109934	385	2.709877	10.43302645	Aiolochroia crassa	261677	Porifera	other_Eukaryota	148	4.559999999999999e-31	NTclustered	gi\|512765256\|gb\|KC869494.1\|	261677	g107123	i0	87.121	32.3298701298701	132	16	34	1	39	169	1206	1337	Aiolochroia crassa voucher P04 28S ribosomal RNA gene, partial sequence	blastn	12447	148	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Verongiida	Aplysinidae	Aiolochroia	Aiolochroia crassa
33047894	33047894	PRJEB20058_P_NODE_38941_length_674_cov_12.698206_g36312_i0	PRJEB20058	38941	674	12.698206	85.58590844	Corticium candelabrum	121492	Porifera	other_Eukaryota	57	1.69e-5	NR	XP_062504471.1	121492	g36312	i0	42.2	1.10830860534125	83	44	36.5	3	251	6	347	426	XP_062504471.1 uncharacterized protein LOC134181246 isoform X2 [Corticium candelabrum]	diamond	747	57	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum

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