metadata: contig_metadata: 7 rows where bioproject = "PRJEB81171", tax_clade = "Opisthokonta" and tax

7 rows where bioproject = "PRJEB81171", 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
1413987	1413987	PRJEB81171_P_NODE_362_length_1055_cov_1.846232_g279_i0	PRJEB81171	362	1055	1.846232	19.4777476	Sycon ciliatum	27933	Porifera	other_Eukaryota	93.2	1.4e-16	NR	XP_065194561.1	27933	g279	i0	38.8	0.366824644549763	129	74	35.8	3	239	616	308	434	XP_065194561.1 multiple C2 and transmembrane domain-containing protein 2-like isoform X4 [Sycon ciliatum]	diamond	387	93.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
11618042	11618042	PRJEB81171_P_NODE_8670_length_248_cov_0.891429_g8543_i0	PRJEB81171	8670	248	0.891429	2.21074392	Sycon ciliatum	27933	Porifera	other_Eukaryota	86.1	2.21e-12	NTclustered	gi\|457866954\|emb\|HF570271.1\|	27933	g8543	i0	89.552	0.810483870967742	67	7	27	0	149	215	988	922	Sycon ciliatum mRNA for Cysteine proteinase Cathepsin F (catL gene)	blastn	201	86.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
29869055	29869055	PRJEB81171_P_NODE_8831_length_247_cov_1.344828_g8704_i0	PRJEB81171	8831	247	1.344828	3.32172516	root	1	Root_unresolved	Root_unresolved	102	3.99e-23	NR	XP_064399854.1	6063	g8704	i0	57.8	9.86234817813765	83	34	99.6	1	1	246	285	367	XP_064399854.1 von Willebrand factor A domain-containing protein 5A-like [Halichondria panicea]	diamond	2436	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30002839	30002839	PRJEB81171_P_NODE_5611_length_285_cov_1.221698_g5484_i0	PRJEB81171	5611	285	1.221698	3.4818393	Oscarella lobularis	121494	Porifera	other_Eukaryota	67	1.81e-10	NR	XP_065846548.1	121494	g5484	i0	38	7.38947368421053	92	56	95.8	1	274	2	964	1055	XP_065846548.1 LOW QUALITY PROTEIN: lysosomal alpha-mannosidase-like [Oscarella lobularis]	diamond	2106	67.4	0.99406528189911	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
30343453	30343453	PRJEB81171_P_NODE_6332_length_274_cov_0.860697_g6205_i0	PRJEB81171	6332	274	0.860697	2.35830978	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	79.7	3.06e-15	NR	KAI6653740.1	111878	g6205	i0	60.9	3.77737226277372	69	27	75.5	0	212	6	7	75	KAI6653740.1 hypothetical protein LOD99_3244 [Oopsacas minuta]	diamond	1035	80.1	0.995006242197254	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
31994082	31994082	PRJEB81171_P_NODE_2198_length_447_cov_3.558824_g2073_i0	PRJEB81171	2198	447	3.558824	15.90794328	Oscarella lobularis	121494	Porifera	other_Eukaryota	195	1.59e-61	NR	XP_065826293.1	121494	g2073	i0	73.1	11.3691275167785	130	35	87.2	0	436	47	1	130	XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis]	diamond	5082	195	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
32657759	32657759	PRJEB81171_P_NODE_6760_length_267_cov_1.206186_g6633_i0	PRJEB81171	6760	267	1.206186	3.22051662	Oscarella lobularis	121494	Porifera	other_Eukaryota	68.9	2.96e-11	NR	XP_065836416.1	121494	g6633	i0	36.5	0.955056179775281	85	53	95.5	1	3	257	560	643	XP_065836416.1 tyrosine-protein phosphatase non-receptor type 9-like [Oscarella lobularis]	diamond	255	68.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis

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