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

5 rows where bioproject = "PRJNA478247", tax_kingdom = "Metazoa" and tax_phylum = "Echinodermata"

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
9375582	9375582	PRJNA478247_P_NODE_268_length_951_cov_4.037961_g204_i0	PRJNA478247	268	951	4.037961	38.40100911	Opisthokonta	33154	Echinodermata	other_Eukaryota	233	2.0999999999999997e-68	NR	XP_063966105.1	7653	g204	i0	62.8	28.4195583596215	191	66	60.3	2	32	604	1	186	XP_063966105.1 large ribosomal subunit protein uL18-like [Lytechinus pictus]	diamond	27027	233	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
15750417	15750417	PRJNA478247_P_NODE_273_length_945_cov_4.156114_g204_i1	PRJNA478247	273	945	4.156114	39.2752773	Opisthokonta	33154	Echinodermata	other_Eukaryota	233	1.9699999999999997e-68	NR	XP_063966105.1	7653	g204	i1	62.8	28.6	191	66	60.6	2	32	604	1	186	XP_063966105.1 large ribosomal subunit protein uL18-like [Lytechinus pictus]	diamond	27027	233	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
26855000	26855000	PRJNA478247_P_NODE_1761_length_270_cov_2.701245_g1655_i0	PRJNA478247	1761	270	2.701245	7.2933615	Diadema antillarum	105358	Echinodermata	other_Eukaryota	65.1	7.6e-11	NR	XP_071491730.1	105358	g1655	i0	40.7	1.01111111111111	91	49	95.6	2	9	266	11	101	XP_071491730.1 calmodulin-like [Diadema antillarum]	diamond	273	65.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
27392487	27392487	PRJNA478247_P_NODE_1083_length_385_cov_2.438202_g977_i0	PRJNA478247	1083	385	2.438202	9.3870777	Diadema antillarum	105358	Echinodermata	other_Eukaryota	127	3.5e-35	NR	XP_071499965.1	105358	g977	i0	56.1	2.6961038961039	123	46	95.8	2	12	380	1	115	XP_071499965.1 large ribosomal subunit protein eL31-like [Diadema antillarum]	diamond	1038	127	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
28812840	28812840	PRJNA478247_P_NODE_1028_length_399_cov_3.921622_g922_i0	PRJNA478247	1028	399	3.921622	15.64727178	Diadema antillarum	105358	Echinodermata	other_Eukaryota	132	6.36e-37	NR	XP_071499965.1	105358	g922	i0	55.8	2.75187969924812	129	49	97	2	12	398	1	121	XP_071499965.1 large ribosomal subunit protein eL31-like [Diadema antillarum]	diamond	1098	132	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum

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