metadata: contig_metadata: 6 rows where bioproject = "PRJNA415856", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA415856", 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
24645797	24645797	PRJNA415856_P_NODE_45180_length_163_cov_2.359649_g44919_i0	PRJNA415856	45180	163	2.359649	3.84622787	Aiolochroia crassa	261677	Porifera	other_Eukaryota	296	5.68e-76	NTclustered	gi\|2802839310\|emb\|OZ181693.1\|	261677	g44919	i0	99.39	14.2822085889571	164	0	100	1	1	163	9680	9843	Aiolochroia crassa genome assembly, organelle: mitochondrion	blastn	2328	296	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Verongiida	Aplysinidae	Aiolochroia	Aiolochroia crassa
26948915	26948915	PRJNA415856_P_NODE_26082_length_181_cov_1.545455_g25821_i0	PRJNA415856	26082	181	1.545455	2.79727355	Dysidea avara	196820	Porifera	other_Eukaryota	77.4	5.49e-15	NR	XP_065912646.1	196820	g25821	i0	59.3	9.0828729281768	59	24	97.8	0	1	177	110	168	XP_065912646.1 pro-cathepsin H-like isoform X2 [Dysidea avara]	diamond	1644	77.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
27328560	27328560	PRJNA415856_P_NODE_14783_length_226_cov_1.152542_g14522_i0	PRJNA415856	14783	226	1.152542	2.60474492	Dysidea avara	196820	Porifera	other_Eukaryota	84.7	3.43e-18	NR	XP_065914948.1	196820	g14522	i0	72.1	0.809734513274336	61	17	81	0	185	3	7	67	XP_065914948.1 charged multivesicular body protein 1a-like [Dysidea avara]	diamond	183	84.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
30423489	30423489	PRJNA415856_P_NODE_50533_length_162_cov_0.902655_g50272_i0	PRJNA415856	50533	162	0.902655	1.4623011	Corticium candelabrum	121492	Porifera	other_Eukaryota	60.8	5.11e-9	NR	XP_062522743.1	121492	g50272	i0	55.8	1.92592592592593	52	23	96.3	0	1	156	36	87	XP_062522743.1 uncharacterized protein LOC134197433 isoform X2 [Corticium candelabrum]	diamond	312	60.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
31655635	31655635	PRJNA415856_P_NODE_26517_length_180_cov_2.114504_g26256_i0	PRJNA415856	26517	180	2.114504	3.8061072	Halichondria panicea	6063	Porifera	other_Eukaryota	52.4	6.04e-6	NR	XP_064400681.1	6063	g26256	i0	44.2	1.73333333333333	52	29	86.7	0	157	2	202	253	XP_064400681.1 TNF receptor-associated factor 3-like [Halichondria panicea]	diamond	312	52.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
32887999	32887999	PRJNA415856_P_NODE_25840_length_182_cov_1.150376_g25579_i0	PRJNA415856	25840	182	1.150376	2.09368432	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	70.1	9.59e-13	NR	XP_011403122.1	400682	g25579	i0	50	0.89010989010989	54	27	89	0	20	181	159	212	XP_011403122.1 PREDICTED: uncharacterized protein LOC105312290 [Amphimedon queenslandica]	diamond	162	70.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica

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