metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA689790" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA689790" 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
9597264	9597264	PRJNA689790_S_NODE_1708_length_505_cov_5.115385_g1599_i0	PRJNA689790	1708	505	5.115385	25.83269425	Metazoa	33208	Echinodermata	other_Eukaryota	115	1.04e-28	NR	XP_797226.3	7668	g1599	i0	41.8	3.47524752475248	146	83	86.7	1	505	68	60	203	XP_797226.3 heme-binding protein 2 [Strongylocentrotus purpuratus]	diamond	1755	115	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
24894921	24894921	PRJNA689790_S_NODE_1700_length_506_cov_4.347548_g1592_i0	PRJNA689790	1700	506	4.347548	21.99859288	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	206	1.6700000000000001e-63	NR	XP_033125693.1	1529436	g1592	i0	65.5	0.877470355731225	148	51	87.7	0	4	447	112	259	XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica]	diamond	444	206	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
24894962	24894962	PRJNA689790_S_NODE_5540_length_255_cov_1.963303_g5425_i0	PRJNA689790	5540	255	1.963303	5.00642265	Asterias rubens	7604	Echinodermata	other_Eukaryota	123	1.68e-32	NR	XP_033639471.1	7604	g5425	i0	69	1.97647058823529	84	26	98.8	0	253	2	102	185	XP_033639471.1 isopentenyl-diphosphate Delta-isomerase 1-like [Asterias rubens]	diamond	504	123	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
26840951	26840951	PRJNA689790_S_NODE_9921_length_188_cov_1.503311_g9806_i0	PRJNA689790	9921	188	1.503311	2.82622468	Metazoa	33208	Echinodermata	other_Eukaryota	82.4	1.04e-18	NR	XP_041472041.1	7654	g9806	i0	97.4	60.6382978723404	38	1	60.6	0	2	115	58	95	XP_041472041.1 protein transport protein Sec61 subunit beta-like [Lytechinus variegatus]	diamond	11400	82.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
27441722	27441722	PRJNA689790_S_NODE_11443_length_176_cov_1.244604_g11328_i0	PRJNA689790	11443	176	1.244604	2.19050304	Metazoa	33208	Echinodermata	other_Eukaryota	112	5.500000000000001e-30	NR	XP_063955038.1	7653	g11328	i0	84.5	663.375	58	9	98.9	0	174	1	73	130	XP_063955038.1 uncharacterized protein LOC135153974 [Lytechinus pictus]	diamond	116754	113	0.991150442477876	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
28325418	28325418	PRJNA689790_S_NODE_8026_length_208_cov_3.333333_g7911_i0	PRJNA689790	8026	208	3.333333	6.93333264	root	1	Root_unresolved	Root_unresolved	105	1.69e-26	NR	XP_033640423.1	7604	g7911	i0	75.4	42.7788461538462	69	17	99.5	0	208	2	7	75	XP_033640423.1 60S ribosomal protein L19-like [Asterias rubens]	diamond	8898	105	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
28945802	28945802	PRJNA689790_S_NODE_7768_length_212_cov_1.451429_g7653_i0	PRJNA689790	7768	212	1.451429	3.07702948	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	73.2	3.2e-13	NR	PIK51386.1	307972	g7653	i0	50.8	0.919811320754717	65	29	87.7	2	188	3	99	163	PIK51386.1 hypothetical protein BSL78_11708 [Apostichopus japonicus]	diamond	195	73.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
29493805	29493805	PRJNA689790_S_NODE_8730_length_200_cov_1.435583_g8615_i0	PRJNA689790	8730	200	1.435583	2.871166	Metazoa	33208	Echinodermata	other_Eukaryota	112	4.75e-28	NR	XP_041480745.1	7654	g8615	i0	71.2	29.7	66	19	99	0	199	2	19	84	XP_041480745.1 Y-box factor homolog [Lytechinus variegatus]	diamond	5940	113	0.991150442477876	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
29872747	29872747	PRJNA689790_S_NODE_15231_length_156_cov_1.310924_g15116_i0	PRJNA689790	15231	156	1.310924	2.04504144	Opisthokonta	33154	Echinodermata	other_Eukaryota	55.8	2.76e-7	NR	XP_041469757.1	7654	g15116	i0	50	3.25	46	23	88.5	0	144	7	165	210	XP_041469757.1 delta(14)-sterol reductase TM7SF2-like isoform X1 [Lytechinus variegatus]	diamond	507	56.2	0.99288256227758	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
30745869	30745869	PRJNA689790_S_NODE_7034_length_223_cov_5.252688_g6919_i0	PRJNA689790	7034	223	5.252688	11.71349424	Asterias rubens	7604	Echinodermata	other_Eukaryota	58.2	1.04e-7	NR	XP_033633035.1	7604	g6919	i0	42.4	0.79372197309417	59	33	79.4	1	209	33	728	785	XP_033633035.1 uncharacterized protein LOC117294642 isoform X2 [Asterias rubens]	diamond	177	58.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
31630891	31630891	PRJNA689790_S_NODE_10796_length_181_cov_1.333333_g10681_i0	PRJNA689790	10796	181	1.333333	2.41333273	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	105	1.16e-24	NR	KAJ8047953.1	206669	g10681	i0	80	13.7734806629834	60	12	99.4	0	180	1	19	78	KAJ8047953.1 Dihydropyrimidinase-related protein 3 [Holothuria leucospilota]	diamond	2493	105	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
31737203	31737203	PRJNA689790_S_NODE_4717_length_279_cov_2.119835_g4602_i0	PRJNA689790	4717	279	2.119835	5.91433965	Metazoa	33208	Echinodermata	other_Eukaryota	48.1	4.95e-5	NR	XP_030837588.1	7668	g4602	i0	95.5	1.18279569892473	22	1	23.7	0	279	214	43	64	XP_030837588.1 stress-associated endoplasmic reticulum protein 2-like [Strongylocentrotus purpuratus]	diamond	330	48.5	0.991752577319588	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
31990364	31990364	PRJNA689790_S_NODE_12738_length_168_cov_1.190840_g12623_i0	PRJNA689790	12738	168	1.19084	2.0006112	Opisthokonta	33154	Echinodermata	other_Eukaryota	62.4	1.51e-9	NR	XP_033630784.1	7604	g12623	i0	50.9	7.85714285714286	55	27	98.2	0	167	3	113	167	XP_033630784.1 60S ribosomal protein L3-like [Asterias rubens]	diamond	1320	62.8	0.993630573248408	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
32232343	32232343	PRJNA689790_S_NODE_7958_length_209_cov_4.337209_g7843_i0	PRJNA689790	7958	209	4.337209	9.06476681	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	40.8	0.0348	NR	KAJ8043773.1	206669	g7843	i0	55.6	0.516746411483254	36	16	51.7	0	203	96	64	99	KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota]	diamond	108	40.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota

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