metadata: contig_metadata: 8 rows where bioproject = "PRJNA833575", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA833575", 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
9752508	9752508	PRJNA833575_P_NODE_39648_length_234_cov_0.872727_g39511_i0	PRJNA833575	39648	234	0.872727	2.04218118	Metazoa	33208	Echinodermata	other_Eukaryota	126	1.44e-31	NR	XP_030841994.1	7668	g39511	i0	76.3	44.8717948717949	76	18	97.4	0	7	234	460	535	XP_030841994.1 tubulin-specific chaperone D isoform X1 [Strongylocentrotus purpuratus]	diamond	10500	127	0.992125984251969	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
27623504	27623504	PRJNA833575_P_NODE_39324_length_234_cov_0.872727_g39187_i0	PRJNA833575	39324	234	0.872727	2.04218118	Diadema antillarum	105358	Echinodermata	other_Eukaryota	115	2.899999999999999e-29	NR	XP_071509204.1	105358	g39187	i0	70.9	3.02564102564103	79	20	100	2	1	234	142	218	XP_071509204.1 S-formylglutathione hydrolase-like [Diadema antillarum]	diamond	708	115	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
30149218	30149218	PRJNA833575_P_NODE_45812_length_227_cov_0.911392_g45675_i0	PRJNA833575	45812	227	0.911392	2.06885984	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	108	1.67e-25	NR	XP_063952180.1	7653	g45675	i0	73.8	1.71806167400881	65	17	85.9	0	3	197	347	411	XP_063952180.1 ubiquitin carboxyl-terminal hydrolase 15-like [Lytechinus pictus]	diamond	390	108	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
30781293	30781293	PRJNA833575_P_NODE_24014_length_304_cov_0.919149_g23877_i0	PRJNA833575	24014	304	0.919149	2.79421296	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	119	1.2e-28	NR	PIK55378.1	307972	g23877	i0	48.5	3.87828947368421	99	51	97.7	0	299	3	312	410	PIK55378.1 putative leishmanolysin-like peptidase [Apostichopus japonicus]	diamond	1179	119	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
31160062	31160062	PRJNA833575_P_NODE_31335_length_265_cov_1.908163_g31198_i0	PRJNA833575	31335	265	1.908163	5.05663195	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	45.4	8.29e-4	NR	PIK42566.1	307972	g31198	i0	37.8	0.837735849056604	74	46	83.8	0	255	34	9	82	PIK42566.1 hypothetical protein BSL78_20591 [Apostichopus japonicus]	diamond	222	45.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
31887824	31887824	PRJNA833575_P_NODE_39477_length_234_cov_0.872727_g39340_i0	PRJNA833575	39477	234	0.872727	2.04218118	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	66.2	1.68e-10	NR	XP_041456772.1	7654	g39340	i0	39.2	2.88461538461538	74	44	93.6	1	11	229	82	155	XP_041456772.1 coronin-6-like isoform X2 [Lytechinus variegatus]	diamond	675	66.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
32552657	32552657	PRJNA833575_P_NODE_11519_length_425_cov_2.615169_g11382_i0	PRJNA833575	11519	425	2.615169	11.11446825	Asterias rubens	7604	Echinodermata	other_Eukaryota	160	1.8899999999999998e-46	NR	XP_033634008.1	7604	g11382	i0	65.9	3.69176470588235	138	45	96	2	1	408	93	230	XP_033634008.1 40S ribosomal protein S6-like [Asterias rubens]	diamond	1569	160	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
32615411	32615411	PRJNA833575_P_NODE_30920_length_267_cov_1.434343_g30783_i0	PRJNA833575	30920	267	1.434343	3.82969581	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	89.4	4.77e-20	NR	XP_041460285.1	7654	g30783	i0	54.1	1.66292134831461	74	33	83.1	1	223	2	12	84	XP_041460285.1 serine/arginine-rich splicing factor 7-like isoform X1 [Lytechinus variegatus]	diamond	444	89.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus

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