metadata: contig_metadata: 13 rows where bioproject = "PRJEB20058" and tax

13 rows where bioproject = "PRJEB20058" 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
25929851	25929851	PRJEB20058_P_NODE_7468_length_1553_cov_4.488606_g6288_i0	PRJEB20058	7468	1553	4.488606	69.70805118	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	192	8.4e-49	NR	KAJ8039427.1	206669	g6288	i0	37	1.04314230521571	270	168	52	2	118	924	776	1044	KAJ8039427.1 RNA-directed DNA polymerase from mobile element jockey [Holothuria leucospilota]	diamond	1620	192	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
26062976	26062976	PRJEB20058_P_NODE_24477_length_842_cov_47.883483_g22246_i0	PRJEB20058	24477	842	47.883483	403.17892686	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	194	6.34e-57	NR	XP_041481762.1	7654	g22246	i0	53.1	3.75534441805226	207	70	73	5	23	637	102	283	XP_041481762.1 60S ribosomal protein L5-like [Lytechinus variegatus]	diamond	3162	194	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
26295522	26295522	PRJEB20058_P_NODE_84422_length_449_cov_4.639175_g81633_i0	PRJEB20058	84422	449	4.639175	20.82989575	Metazoa	33208	Echinodermata	other_Eukaryota	52.8	0.043	NTclustered	gi\|2707376467\|ref\|XM_064108887.1\|	7653	g81633	i0	96.774	0.256124721603563	31	1	7	0	382	412	160	130	PREDICTED: Lytechinus pictus uncharacterized LOC135156427 (LOC135156427), mRNA	blastn	115	52.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
26567542	26567542	PRJEB20058_P_NODE_8632_length_1432_cov_3.775346_g6288_i1	PRJEB20058	8632	1432	3.775346	54.06295472	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	192	3.36e-49	NR	KAJ8039427.1	206669	g6288	i1	37	1.13128491620112	270	168	56.4	2	1315	509	776	1044	KAJ8039427.1 RNA-directed DNA polymerase from mobile element jockey [Holothuria leucospilota]	diamond	1620	192	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
32991429	32991429	PRJEB20058_P_NODE_183195_length_272_cov_5.663507_g180372_i0	PRJEB20058	183195	272	5.663507	15.40473904	root	1	Root_unresolved	Root_unresolved	72.4	1.91e-12	NR	KAJ8043891.1	206669	g180372	i0	45.1	1.88602941176471	82	44	90.4	1	27	272	523	603	KAJ8043891.1 hypothetical protein HOLleu_11191 [Holothuria leucospilota]	diamond	513	72.8	0.994505494505495	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
33008221	33008221	PRJEB20058_P_NODE_107939_length_389_cov_10.435976_g105128_i0	PRJEB20058	107939	389	10.435976	40.59594664	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	87.8	6.49e-18	NR	XP_786407.1	7668	g105128	i0	44.8	4.98971722365039	105	51	76.3	4	349	53	184	287	XP_786407.1 thioredoxin-like protein 1 [Strongylocentrotus purpuratus]	diamond	1941	88.6	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
33013794	33013794	PRJEB20058_P_NODE_40540_length_661_cov_3.291667_g37898_i0	PRJEB20058	40540	661	3.291667	21.75791887	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	48.9	0.00791	NR	XP_030840267.1	7668	g37898	i0	39.2	0.335854765506808	74	42	32.7	2	18	233	389	461	XP_030840267.1 uncharacterized protein LOC115923526 [Strongylocentrotus purpuratus]	diamond	222	48.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
33025561	33025561	PRJEB20058_P_NODE_21748_length_892_cov_22.883273_g19609_i0	PRJEB20058	21748	892	22.883273	204.11879516	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	159	1.64e-42	NR	XP_033642101.1	7604	g19609	i0	41.4	6.30269058295964	232	105	72.6	6	52	699	95	311	XP_033642101.1 E3 ubiquitin-protein ligase RGLG4-like isoform X2 [Asterias rubens]	diamond	5622	159	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
33031308	33031308	PRJEB20058_P_NODE_95316_length_419_cov_1.899441_g92514_i0	PRJEB20058	95316	419	1.899441	7.95865779	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	74.3	2.36e-12	NR	XP_033118382.1	1529436	g92514	i0	41.1	1.23866348448687	90	46	59.4	2	285	37	144	233	XP_033118382.1 putative cation exchanger C521.04c [Anneissia japonica]	diamond	519	74.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
33081711	33081711	PRJEB20058_P_NODE_199902_length_256_cov_4.256410_g197078_i0	PRJEB20058	199902	256	4.25641	10.8964096	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	80.5	2.37e-16	NR	KAJ8050171.1	206669	g197078	i0	44.9	1.8046875	78	41	89.1	1	28	255	106	183	KAJ8050171.1 hypothetical protein HOLleu_03267 [Holothuria leucospilota]	diamond	462	80.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
33093686	33093686	PRJEB20058_P_NODE_151078_length_312_cov_2.545817_g148256_i0	PRJEB20058	151078	312	2.545817	7.94294904	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.8	3.55e-5	NR	XP_038071266.1	46514	g148256	i0	51.2	1.19230769230769	41	20	39.4	0	222	100	106	146	XP_038071266.1 cystatin-A-like [Patiria miniata]	diamond	372	51.2	0.9921875	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
33115660	33115660	PRJEB20058_P_NODE_174263_length_282_cov_8.167421_g171440_i0	PRJEB20058	174263	282	8.167421	23.03212722	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	45.8	0.00518	NR	XP_030837463.1	7668	g171440	i0	37.9	0.617021276595745	58	34	61.7	1	70	243	511	566	XP_030837463.1 multidrug resistance-associated protein 5 isoform X1 [Strongylocentrotus purpuratus]	diamond	174	45.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
33179196	33179196	PRJEB20058_P_NODE_77960_length_469_cov_32.338235_g75180_i0	PRJEB20058	77960	469	32.338235	151.66632215	Opisthokonta	33154	Echinodermata	other_Eukaryota	85.5	5.44e-16	NR	XP_033625926.1	7604	g75180	i0	43.1	3.36460554371002	102	57	64.6	1	24	326	1478	1579	XP_033625926.1 ATP-binding cassette sub-family A member 3-like isoform X2 [Asterias rubens]	diamond	1578	85.9	0.9953434225844	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);;