metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax

4 rows where analysis = "diamond", bioproject = "PRJEB6584" 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
33008497	33008497	PRJEB6584h_S_NODE_5099_length_245_cov_2.823810_g5037_i0	PRJEB6584	5099	245	2.82381	6.9183345	Metazoa	33208	Echinodermata	other_Eukaryota	120	1.2699999999999998e-32	NR	XP_030845498.1	7668	g5037	i0	81.7	7.82448979591837	71	13	86.9	0	3	215	78	148	XP_030845498.1 60S ribosomal protein L27a [Strongylocentrotus purpuratus]	diamond	1917	120	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
33014490	33014490	PRJEB6584h_S_NODE_39772_length_167_cov_1.560606_g39710_i0	PRJEB6584	39772	167	1.560606	2.60621202	Asterias rubens	7604	Echinodermata	other_Eukaryota	70.9	4.81e-14	NR	XP_033640987.1	7604	g39710	i0	72.7	1.97604790419162	55	15	98.8	0	2	166	39	93	XP_033640987.1 ATPase inhibitor A, mitochondrial-like [Asterias rubens]	diamond	330	70.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
33093951	33093951	PRJEB6584o_S_NODE_58158_length_163_cov_2.351562_g58050_i0	PRJEB6584	58158	163	2.351562	3.83304606	Metazoa	33208	Echinodermata	other_Eukaryota	80.1	3.52e-17	NR	XP_054756763.1	7653	g58050	i0	71.2	4.89570552147239	52	15	95.7	0	162	7	112	163	XP_054756763.1 large ribosomal subunit protein uL11-like [Lytechinus pictus]	diamond	798	80.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
33167760	33167760	PRJEB6584a_S_NODE_2632_length_229_cov_533.778351_g2612_i0	PRJEB6584	2632	229	533.778351	1222.35242379	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	44.3	0.00857	NR	PIK62516.1	307972	g2612	i0	47.5	1.89956331877729	40	18	48.5	1	109	219	30	69	PIK62516.1 hypothetical protein BSL78_00522 [Apostichopus japonicus]	diamond	435	44.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus

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