metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA450343" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA450343" 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
14467702	14467702	PRJNA450343_P_NODE_5232_length_232_cov_1.180328_g5164_i0	PRJNA450343	5232	232	1.180328	2.73836096	Metazoa	33208	Echinodermata	other_Eukaryota	139	5.29e-38	NR	XP_041458658.1	7654	g5164	i0	84.4	16.926724137931	77	12	99.6	0	231	1	247	323	XP_041458658.1 procathepsin L-like [Lytechinus variegatus]	diamond	3927	139	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
20218709	20218709	PRJNA450343_P_NODE_10296_length_169_cov_1.700000_g10228_i0	PRJNA450343	10296	169	1.7	2.873	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99.4	1.5400000000000001e-22	NR	XP_033647297.1	7604	g10228	i0	85.2	50.2011834319527	54	8	95.9	0	164	3	550	603	XP_033647297.1 isoleucine--tRNA ligase, cytoplasmic-like [Asterias rubens]	diamond	8484	99.8	0.995991983967936	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
26981107	26981107	PRJNA450343_P_NODE_13822_length_161_cov_0.910714_g13754_i0	PRJNA450343	13822	161	0.910714	1.46624954	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	73.2	2.15e-13	NR	PIK36780.1	307972	g13754	i0	61.8	2.04968944099379	55	19	98.8	1	3	161	236	290	PIK36780.1 hypothetical protein BSL78_26389 [Apostichopus japonicus]	diamond	330	73.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
27377103	27377103	PRJNA450343_P_NODE_13103_length_162_cov_2.256637_g13035_i0	PRJNA450343	13103	162	2.256637	3.65575194	Opisthokonta	33154	Echinodermata	other_Eukaryota	43.5	0.00684	NR	KAJ8038107.1	206669	g13035	i0	52	1.7962962962963	50	22	88.9	1	147	4	262	311	KAJ8038107.1 Cytochrome b-c1 complex subunit 2, mitochondrial [Holothuria leucospilota]	diamond	291	43.9	0.990888382687927	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
27440254	27440254	PRJNA450343_P_NODE_11443_length_166_cov_0.871795_g11375_i0	PRJNA450343	11443	166	0.871795	1.4471797	Echinodermata	7586	Echinodermata	other_Eukaryota	61.2	3.32e-9	NR	XP_038065191.1	46514	g11375	i0	57.8	4.01204819277108	45	18	79.5	1	147	16	266	310	XP_038065191.1 sulfotransferase 1C2-like isoform X3 [Patiria miniata]	diamond	666	61.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
30202225	30202225	PRJNA450343_P_NODE_9052_length_181_cov_1.545455_g8984_i0	PRJNA450343	9052	181	1.545455	2.79727355	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	50.8	2.32e-5	NR	XP_033108491.1	1529436	g8984	i0	34.4	1.01104972375691	61	33	91.2	2	13	177	1375	1434	XP_033108491.1 fibropellin-1-like [Anneissia japonica]	diamond	183	50.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
31577770	31577770	PRJNA450343_P_NODE_5056_length_236_cov_0.957219_g4988_i0	PRJNA450343	5056	236	0.957219	2.25903684	Metazoa	33208	Echinodermata	other_Eukaryota	45.1	0.00541	NR	XP_030829916.1	7668	g4988	i0	55.9	4.66525423728814	34	14	41.9	1	4	102	2710	2743	XP_030829916.1 low-density lipoprotein receptor-related protein 1 [Strongylocentrotus purpuratus]	diamond	1101	45.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
31656137	31656137	PRJNA450343_P_NODE_2797_length_323_cov_1.532847_g2729_i0	PRJNA450343	2797	323	1.532847	4.95109581	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	80.5	4.74e-15	NR	XP_033097464.1	1529436	g2729	i0	41.7	0.891640866873065	96	55	89.2	1	290	3	324	418	XP_033097464.1 cytochrome b-c1 complex subunit 2, mitochondrial-like [Anneissia japonica]	diamond	288	80.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
31909400	31909400	PRJNA450343_P_NODE_3697_length_277_cov_2.451754_g3629_i0	PRJNA450343	3697	277	2.451754	6.79135858	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	112	6.919999999999999e-28	NR	PIK51398.1	307972	g3629	i0	73.7	0.823104693140794	76	20	82.3	0	10	237	198	273	PIK51398.1 hypothetical protein BSL78_11720 [Apostichopus japonicus]	diamond	228	112	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
32590185	32590185	PRJNA450343_P_NODE_5359_length_230_cov_0.845304_g5291_i0	PRJNA450343	5359	230	0.84530400000000006	1.9441992	Metazoa	33208	Echinodermata	other_Eukaryota	105	4.96e-26	NR	XP_033625406.1	7604	g5291	i0	60.5	4.87826086956522	76	30	99.1	0	230	3	71	146	XP_033625406.1 translin-like [Asterias rubens]	diamond	1122	105	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens

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