metadata: contig_metadata: 4 rows where bioproject = "PRJNA278119", tax_kingdom = "Metazoa" and tax

4 rows where bioproject = "PRJNA278119", tax_kingdom = "Metazoa" 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
11849669	11849669	PRJNA278119_P_NODE_14050_length_295_cov_1.365854_g13801_i0	PRJNA278119	14050	295	1.365854	4.0292693	Patiria miniata	46514	Echinodermata	other_Eukaryota	159	1.57e-34	NTclustered	gi\|1944890639\|ref\|XM_038204743.1\|	46514	g13801	i0	80.676	42.9084745762712	207	38	69	2	59	263	377	171	PREDICTED: Patiria miniata ras-related protein Rab-7a (LOC119731566), transcript variant X1, mRNA	blastn	12658	159	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
29568704	29568704	PRJNA278119_P_NODE_42770_length_164_cov_1.356522_g42521_i0	PRJNA278119	42770	164	1.356522	2.22469608	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	82.4	1.28e-16	NR	PIK54383.1	307972	g42521	i0	100	0.695121951219512	38	0	69.5	0	51	164	1	38	PIK54383.1 putative proton-coupled folate transporter [Apostichopus japonicus]	diamond	114	82.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
32034004	32034004	PRJNA278119_P_NODE_42458_length_165_cov_0.887931_g42209_i0	PRJNA278119	42458	165	0.887931	1.46508615	Patiria miniata	46514	Echinodermata	other_Eukaryota	92.8	2.23e-21	NR	XP_038051326.1	46514	g42209	i0	79.6	5.89090909090909	54	11	98.2	0	3	164	102	155	XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata]	diamond	972	92.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
32508865	32508865	PRJNA278119_P_NODE_9179_length_389_cov_1.223529_g8932_i0	PRJNA278119	9179	389	1.223529	4.75952781	Asterias rubens	7604	Echinodermata	other_Eukaryota	80.5	5.1e-15	NR	XP_033629823.1	7604	g8932	i0	45.3	0.663239074550129	86	44	66.3	1	321	64	68	150	XP_033629823.1 metallophosphoesterase MPPED2-like isoform X1 [Asterias rubens]	diamond	258	80.5	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);;