metadata: contig_metadata: 5 rows where bioproject = "PRJNA380660", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA380660", tax_kingdom = "Metazoa" 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
22751053	22751053	PRJNA380660_P_NODE_6038_length_310_cov_6.217082_g5638_i0	PRJNA380660	6038	310	6.217082	19.2729542	Haplosclerida	6049	Porifera	other_Eukaryota	124	6.049999999999999e-24	NTclustered	gi\|1284883228\|gb\|KY825184.1\|	178514	g5638	i0	80.114	9.83225806451613	176	28	56	5	138	310	3474	3303	Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence	blastn	3048	124	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon compressa
26916830	26916830	PRJNA380660_P_NODE_10702_length_195_cov_2.084337_g10302_i0	PRJNA380660	10702	195	2.084337	4.06445715	Oscarella lobularis	121494	Porifera	other_Eukaryota	76.3	3.04e-14	NR	XP_065836415.1	121494	g10302	i0	84.2	1.36923076923077	38	6	58.5	0	82	195	452	489	XP_065836415.1 aldehyde dehydrogenase, mitochondrial-like isoform X2 [Oscarella lobularis]	diamond	267	76.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
27233059	27233059	PRJNA380660_P_NODE_7363_length_266_cov_2.523207_g6963_i0	PRJNA380660	7363	266	2.523207	6.71173062	Oscarella lobularis	121494	Porifera	other_Eukaryota	43.5	0.0276	NR	XP_065833382.1	121494	g6963	i0	27.4	0.823308270676692	73	48	82.3	2	15	233	1984	2051	XP_065833382.1 ubiquitin carboxyl-terminal hydrolase 34-like [Oscarella lobularis]	diamond	219	43.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
28211778	28211778	PRJNA380660_P_NODE_11166_length_186_cov_2.101911_g10766_i0	PRJNA380660	11166	186	2.101911	3.90955446	Corticium candelabrum	121492	Porifera	other_Eukaryota	89.7	4.55e-19	NR	XP_062508004.1	121492	g10766	i0	62.9	2	62	23	100	0	1	186	407	468	XP_062508004.1 protein disulfide-isomerase-like [Corticium candelabrum]	diamond	372	89.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
29569624	29569624	PRJNA380660_P_NODE_5230_length_343_cov_1.847134_g4832_i0	PRJNA380660	5230	343	1.847134	6.33566962	Halichondria panicea	6063	Porifera	other_Eukaryota	66.6	3.81e-10	NR	XP_064391539.1	6063	g4832	i0	42.3	4.4868804664723	104	52	91	1	336	25	207	302	XP_064391539.1 AH receptor-interacting protein-like isoform X2 [Halichondria panicea]	diamond	1539	66.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea

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