metadata: contig_metadata: 13 rows where bioproject = "PRJNA630877", tax_clade = "Opisthokonta" and tax

13 rows where bioproject = "PRJNA630877", tax_clade = "Opisthokonta" 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
12082559	12082559	PRJNA630877_S_NODE_146230_length_161_cov_1.833333_g127093_i0	PRJNA630877	146230	161	1.833333	2.95166613	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	54.7	0.004	NTclustered	gi\|2707361341\|ref\|XM_054910378.2\|	7653	g127093	i0	90.244	0.254658385093168	41	4	25	0	96	136	1240	1200	PREDICTED: Lytechinus pictus uncharacterized LOC129273354 (LOC129273354), mRNA	blastn	41	54.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
26700852	26700852	PRJNA630877_S_NODE_86541_length_267_cov_2.141593_g67404_i0	PRJNA630877	86541	267	2.141593	5.71805331	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	42.7	0.00827	NR	KAJ8022747.1	206669	g67404	i0	45.8	0.539325842696629	48	22	53.9	1	204	61	31	74	KAJ8022747.1 hypothetical protein HOLleu_37732 [Holothuria leucospilota]	diamond	144	42.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
26764326	26764326	PRJNA630877_S_NODE_98941_length_230_cov_1.137566_g79804_i0	PRJNA630877	98941	230	1.137566	2.6164018000000002	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	62	4.5e-9	NR	KAJ8035721.1	206669	g79804	i0	55.9	1.64347826086957	59	25	77	1	184	8	137	194	KAJ8035721.1 hypothetical protein HOLleu_19484 [Holothuria leucospilota]	diamond	378	62	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
27302235	27302235	PRJNA630877_S_NODE_124143_length_184_cov_21.909091_g105006_i0	PRJNA630877	124143	184	21.909091	40.31272744	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	121	3.96e-30	NR	XP_033115342.1	1529436	g105006	i0	94.9	54.7336956521739	59	3	96.2	0	181	5	251	309	XP_033115342.1 clathrin heavy chain 1 isoform X2 [Anneissia japonica]	diamond	10071	122	0.991803278688525	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
27333910	27333910	PRJNA630877_S_NODE_146903_length_161_cov_1.100000_g127766_i0	PRJNA630877	146903	161	1.1	1.771	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	47.4	3.12e-5	NR	KAJ8021317.1	206669	g127766	i0	57.1	0.782608695652174	42	16	74.5	1	144	25	5	46	KAJ8021317.1 hypothetical protein HOLleu_38482 [Holothuria leucospilota]	diamond	126	47.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
29133692	29133692	PRJNA630877_S_NODE_85709_length_270_cov_2.026201_g66572_i0	PRJNA630877	85709	270	2.026201	5.4707427	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	45.8	0.00378	NR	PIK52076.1	307972	g66572	i0	41.2	0.566666666666667	51	29	56.7	1	17	169	1	50	PIK52076.1 hypothetical protein BSL78_11028 [Apostichopus japonicus]	diamond	153	45.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
29291348	29291348	PRJNA630877_S_NODE_29929_length_1051_cov_3.019802_g16648_i0	PRJNA630877	29929	1051	3.019802	31.73811902	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	56.6	1.3e-4	NR	XP_033102325.1	1529436	g16648	i0	58.8	0.393910561370124	34	14	9.7	0	1047	946	119	152	XP_033102325.1 SCO-spondin-like [Anneissia japonica]	diamond	414	56.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
29701459	29701459	PRJNA630877_S_NODE_65930_length_383_cov_1.994152_g46795_i0	PRJNA630877	65930	383	1.994152	7.63760216	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	76.3	3.44e-13	NR	KAJ8044616.1	206669	g46795	i0	53	0.516971279373368	66	31	51.7	0	338	141	407	472	KAJ8044616.1 RNA-directed DNA polymerase from mobile element jockey [Holothuria leucospilota]	diamond	198	76.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
30030340	30030340	PRJNA630877_S_NODE_108271_length_209_cov_3.029762_g89134_i0	PRJNA630877	108271	209	3.029762	6.33220258	Metazoa	33208	Echinodermata	other_Eukaryota	50.4	4.57e-5	NR	XP_038068605.1	46514	g89134	i0	67.7	0.861244019138756	31	10	44.5	0	207	115	393	423	XP_038068605.1 zinc finger protein 341-like isoform X2 [Patiria miniata]	diamond	180	50.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
30649323	30649323	PRJNA630877_S_NODE_40873_length_746_cov_19.201418_g23983_i0	PRJNA630877	40873	746	19.201418	143.24257828	Patiria miniata	46514	Echinodermata	other_Eukaryota	141	2.84e-35	NR	XP_038064513.1	46514	g23983	i0	54.7	0.550938337801609	137	56	54.7	3	52	459	322	453	XP_038064513.1 uncharacterized protein LOC119734943 [Patiria miniata]	diamond	411	141	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
32040767	32040767	PRJNA630877_S_NODE_36378_length_858_cov_3.801714_g20807_i0	PRJNA630877	36378	858	3.801714	32.61870612	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	139	5.5700000000000005e-33	NR	KAJ8044616.1	206669	g20807	i0	37	1.5034965034965	200	120	69.2	4	236	829	97	292	KAJ8044616.1 RNA-directed DNA polymerase from mobile element jockey [Holothuria leucospilota]	diamond	1290	139	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
32388799	32388799	PRJNA630877_S_NODE_56519_length_478_cov_3.338673_g37487_i0	PRJNA630877	56519	478	3.338673	15.95885694	Acanthaster planci	133434	Echinodermata	other_Eukaryota	46.6	0.0183	NR	XP_022102107.1	133434	g37487	i0	50	0.288702928870293	46	23	28.9	0	292	155	244	289	XP_022102107.1 mediator of RNA polymerase II transcription subunit 15a-like [Acanthaster planci]	diamond	138	46.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
32433242	32433242	PRJNA630877_S_NODE_32579_length_964_cov_24.151679_g18291_i0	PRJNA630877	32579	964	24.151679	232.82218556	Opisthokonta	33154	Echinodermata	other_Eukaryota	56.6	1.03e-4	NR	XP_071506804.1	105358	g18291	i0	48.8	0.70954356846473	43	22	13.4	0	963	835	1014	1056	XP_071506804.1 uncharacterized protein [Diadema antillarum]	diamond	684	57	0.992982456140351	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);;