metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA874604" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA874604" 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
12330512	12330512	PRJNA874604_P_NODE_16830_length_432_cov_1.685237_g16478_i0	PRJNA874604	16830	432	1.685237	7.28022384	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	155	2.73e-45	NR	XP_041463361.1	7654	g16478	i0	63.9	4.95833333333333	119	43	82.6	0	408	52	1	119	XP_041463361.1 60S ribosomal protein L24-like [Lytechinus variegatus]	diamond	2142	156	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
21640457	21640457	PRJNA874604_P_NODE_89197_length_244_cov_1.584795_g88845_i0	PRJNA874604	89197	244	1.584795	3.8668998	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	120	1.4999999999999996e-29	NR	XP_041479466.1	7654	g88845	i0	65.8	53.3114754098361	79	27	97.1	0	3	239	157	235	XP_041479466.1 coatomer subunit beta'-like isoform X2 [Lytechinus variegatus]	diamond	13008	120	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
26643547	26643547	PRJNA874604_P_NODE_13281_length_478_cov_1.133333_g12929_i0	PRJNA874604	13281	478	1.133333	5.41733174	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	86.3	2.81e-16	NR	XP_041455689.1	7654	g12929	i0	38.3	1.21129707112971	115	63	67.2	1	321	1	91	205	XP_041455689.1 amine oxidase [flavin-containing] B-like [Lytechinus variegatus]	diamond	579	86.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
26706742	26706742	PRJNA874604_P_NODE_34001_length_329_cov_1.097656_g33649_i0	PRJNA874604	34001	329	1.097656	3.61128824	Acanthaster planci	133434	Echinodermata	other_Eukaryota	62	3.44e-9	NR	XP_022083746.1	133434	g33649	i0	34.1	2.04255319148936	82	43	74.8	1	253	8	3	73	XP_022083746.1 serine/arginine-rich splicing factor 3-like [Acanthaster planci]	diamond	672	62	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
27055340	27055340	PRJNA874604_P_NODE_72702_length_250_cov_0.870056_g72350_i0	PRJNA874604	72702	250	0.870056	2.17514	Acanthaster planci	133434	Echinodermata	other_Eukaryota	75.5	1.2e-13	NR	XP_022080625.1	133434	g72350	i0	58.9	0.672	56	22	66	1	250	86	128	183	XP_022080625.1 pre-mRNA-splicing factor SLU7-like [Acanthaster planci]	diamond	168	75.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
27568728	27568728	PRJNA874604_P_NODE_62224_length_262_cov_1.391534_g61872_i0	PRJNA874604	62224	262	1.391534	3.64581908	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	122	6.889999999999999e-31	NR	XP_063958741.1	7653	g61872	i0	67.8	24.9045801526718	87	28	99.6	0	261	1	90	176	XP_063958741.1 DNA repair protein RAD51 homolog A [Lytechinus pictus]	diamond	6525	123	0.991869918699187	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
29778964	29778964	PRJNA874604_P_NODE_95311_length_242_cov_1.278107_g94959_i0	PRJNA874604	95311	242	1.278107	3.09301894	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	68.2	9.17e-12	NR	XP_041485602.1	7654	g94959	i0	47	2.52892561983471	66	35	81.8	0	241	44	36	101	XP_041485602.1 S-crystallin SL11-like isoform X2 [Lytechinus variegatus]	diamond	612	68.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
29802457	29802457	PRJNA874604_P_NODE_90571_length_244_cov_0.900585_g90219_i0	PRJNA874604	90571	244	0.900585	2.1974274	Asterias rubens	7604	Echinodermata	other_Eukaryota	59.7	4.16e-8	NR	XP_033646781.1	7604	g90219	i0	54.3	2.25	46	20	56.6	1	243	106	315	359	XP_033646781.1 stabilin-2-like isoform X2 [Asterias rubens]	diamond	549	59.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
30055070	30055070	PRJNA874604_P_NODE_72251_length_250_cov_0.870056_g71899_i0	PRJNA874604	72251	250	0.870056	2.17514	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	50.8	5.31e-5	NR	XP_041475102.1	7654	g71899	i0	56.8	0.912	37	16	44.4	0	143	33	16	52	XP_041475102.1 fibropellin-1-like [Lytechinus variegatus]	diamond	228	50.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
30181533	30181533	PRJNA874604_P_NODE_98472_length_241_cov_0.916667_g98120_i0	PRJNA874604	98472	241	0.916667	2.20916747	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	68.9	2.12e-11	NR	PIK57504.1	307972	g98120	i0	35	2.95020746887967	80	52	99.6	0	2	241	249	328	PIK57504.1 hypothetical protein BSL78_05568 [Apostichopus japonicus]	diamond	711	68.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
30560497	30560497	PRJNA874604_P_NODE_13393_length_476_cov_1.503722_g13041_i0	PRJNA874604	13393	476	1.503722	7.15771672	Patiria miniata	46514	Echinodermata	other_Eukaryota	228	1.7e-72	NR	XP_038051326.1	46514	g13041	i0	73.2	0.894957983193277	142	38	89.5	0	3	428	105	246	XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata]	diamond	426	228	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
31160697	31160697	PRJNA874604_P_NODE_39455_length_311_cov_1.126050_g39103_i0	PRJNA874604	39455	311	1.12605	3.5020155	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	43.9	0.0333	NR	XP_030833827.1	7668	g39103	i0	32.9	0.790996784565916	82	44	75.2	4	66	299	510	584	XP_030833827.1 sushi domain-containing protein 2 [Strongylocentrotus purpuratus]	diamond	246	43.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
31698756	31698756	PRJNA874604_P_NODE_82597_length_247_cov_0.885057_g82245_i0	PRJNA874604	82597	247	0.885057	2.18609079	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	75.9	8.3e-14	NR	XP_033110246.1	1529436	g82245	i0	44.7	2.06477732793522	85	42	99.6	3	247	2	297	379	XP_033110246.1 arachidonate 5-lipoxygenase-like isoform X2 [Anneissia japonica]	diamond	510	75.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
32023192	32023192	PRJNA874604_P_NODE_78918_length_248_cov_0.880000_g78566_i0	PRJNA874604	78918	248	0.88	2.1824	Metazoa	33208	Echinodermata	other_Eukaryota	56.6	3.69e-7	NR	XP_033646025.1	7604	g78566	i0	39.2	9.32661290322581	79	43	89.5	2	226	5	9	87	XP_033646025.1 CD151 antigen-like [Asterias rubens]	diamond	2313	56.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
32023196	32023196	PRJNA874604_P_NODE_91618_length_244_cov_0.900585_g91266_i0	PRJNA874604	91618	244	0.900585	2.1974274	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47.4	8.74e-4	NR	XP_022095373.1	133434	g91266	i0	42.9	3.23360655737705	49	27	59	1	6	149	1029	1077	XP_022095373.1 delphilin-like isoform X7 [Acanthaster planci]	diamond	789	47.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
32046775	32046775	PRJNA874604_P_NODE_44778_length_295_cov_4.702703_g44426_i0	PRJNA874604	44778	295	4.702703	13.87297385	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	94	2.69e-22	NR	KAJ8030924.1	206669	g44426	i0	52.7	0.925423728813559	91	42	91.5	1	21	290	1	91	KAJ8030924.1 Profilin-1A [Holothuria leucospilota]	diamond	273	94	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
32647122	32647122	PRJNA874604_P_NODE_54100_length_276_cov_2.655172_g53748_i0	PRJNA874604	54100	276	2.655172	7.32827472	Patiria miniata	46514	Echinodermata	other_Eukaryota	72.8	1.53e-12	NR	XP_038053507.1	46514	g53748	i0	49.3	0.793478260869565	73	36	79.3	1	44	262	442	513	XP_038053507.1 lipoxygenase homology domain-containing protein 1-like isoform X1 [Patiria miniata]	diamond	219	72.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
32686882	32686882	PRJNA874604_P_NODE_91320_length_244_cov_0.900585_g90968_i0	PRJNA874604	91320	244	0.900585	2.1974274	Metazoa	33208	Echinodermata	other_Eukaryota	133	2.3399999999999998e-34	NR	XP_030848513.1	7668	g90968	i0	85.2	58.7581967213115	81	12	99.6	0	243	1	262	342	XP_030848513.1 nucleolar protein 56 [Strongylocentrotus purpuratus]	diamond	14337	134	0.992537313432836	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus

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