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

5 rows where bioproject = "PRJNA637219", 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
26966855	26966855	PRJNA637219_S_NODE_11462_length_166_cov_1.128205_g11417_i0	PRJNA637219	11462	166	1.128205	1.8728203	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	44.7	0.00269	NR	XP_062503430.1	121492	g11417	i0	30.9	1.89759036144578	55	36	95.8	1	161	3	407	461	XP_062503430.1 uncharacterized protein LOC134180315 [Corticium candelabrum]	diamond	315	45.1	0.991130820399113	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
27504466	27504466	PRJNA637219_S_NODE_13983_length_164_cov_0.886957_g13938_i0	PRJNA637219	13983	164	0.886957	1.45460948	root	1	Root_unresolved	Root_unresolved	118	2.24e-30	NR	XP_065196935.1	27933	g13938	i0	98.1	111.621951219512	54	1	98.8	0	162	1	187	240	XP_065196935.1 casein kinase II subunit alpha-like [Sycon ciliatum]	diamond	18306	119	0.991596638655462	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
28091644	28091644	PRJNA637219_S_NODE_11005_length_167_cov_0.864407_g10960_i0	PRJNA637219	11005	167	0.864407	1.44355969	Dysidea avara	196820	Porifera	other_Eukaryota	41.2	0.0461	NR	XP_065889628.1	196820	g10960	i0	40	0.808383233532934	45	27	80.8	0	4	138	176	220	XP_065889628.1 crystallin J1A-like [Dysidea avara]	diamond	135	41.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
28786152	28786152	PRJNA637219_S_NODE_7227_length_192_cov_1.426573_g7182_i0	PRJNA637219	7227	192	1.426573	2.73902016	Halichondria panicea	6063	Porifera	other_Eukaryota	45.8	0.00158	NR	XP_064386088.1	6063	g7182	i0	42.9	0.875	56	30	87.5	1	10	177	406	459	XP_064386088.1 serine palmitoyltransferase 1-like [Halichondria panicea]	diamond	168	45.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30504274	30504274	PRJNA637219_S_NODE_5333_length_215_cov_1.228916_g5288_i0	PRJNA637219	5333	215	1.228916	2.6421694	root	1	Root_unresolved	Root_unresolved	55.1	1.05e-6	NR	AAX48841.1	55567	g5288	i0	45	12.5581395348837	60	33	83.7	0	9	188	139	198	AAX48841.1 L10e/P0 [Suberites domuncula]	diamond	2700	55.5	0.992792792792793	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula

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