metadata: contig_metadata: 4 rows where bioproject = "PRJNA703759", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA703759", 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
26650587	26650587	PRJNA703759_P_NODE_15361_length_346_cov_1.091575_g14885_i0	PRJNA703759	15361	346	1.091575	3.7768495	Metazoa	33208	Porifera	other_Eukaryota	122	1.93e-29	NR	XP_064403052.1	6063	g14885	i0	52.6	34.3612716763006	114	48	98.8	2	344	3	461	568	XP_064403052.1 RNA helicase aquarius-like isoform X1 [Halichondria panicea]	diamond	11889	123	0.991869918699187	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
26766348	26766348	PRJNA703759_P_NODE_46621_length_245_cov_0.906977_g46145_i0	PRJNA703759	46621	245	0.906977	2.22209365	Sycon ciliatum	27933	Porifera	other_Eukaryota	43.5	0.0207	NR	XP_065184105.1	27933	g46145	i0	33.3	0.73469387755102	60	40	73.5	0	230	51	512	571	XP_065184105.1 condensin complex subunit 3-like [Sycon ciliatum]	diamond	180	43.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
27967133	27967133	PRJNA703759_P_NODE_25485_length_283_cov_1.371429_g25009_i0	PRJNA703759	25485	283	1.371429	3.88114407	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	71.2	5.59e-12	NR	XP_019851602.1	400682	g25009	i0	61.7	0.636042402826855	60	23	63.6	0	182	3	646	705	XP_019851602.1 PREDICTED: vam6/Vps39-like protein [Amphimedon queenslandica]	diamond	180	71.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
29861703	29861703	PRJNA703759_P_NODE_43551_length_247_cov_0.896552_g43075_i0	PRJNA703759	43551	247	0.896552	2.21448344	Dysidea avara	196820	Porifera	other_Eukaryota	49.3	2.02e-4	NR	XP_065886866.1	196820	g43075	i0	32.9	2.87854251012146	76	48	88.7	1	10	228	689	764	XP_065886866.1 uncharacterized protein [Dysidea avara]	diamond	711	49.3	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara

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