metadata: contig_metadata: 5 rows where bioproject = "PRJNA807685", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA807685", 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
26673998	26673998	PRJNA807685_P_NODE_52081_length_169_cov_1.553030_g51008_i0	PRJNA807685	52081	169	1.55303	2.6246207	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	60.5	7.41e-9	NR	PIK46835.1	307972	g51008	i0	48.1	2.89349112426035	54	28	95.9	0	164	3	94	147	PIK46835.1 hypothetical protein BSL78_16294 [Apostichopus japonicus]	diamond	489	60.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
27117172	27117172	PRJNA807685_P_NODE_42382_length_188_cov_1.953642_g41309_i0	PRJNA807685	42382	188	1.953642	3.67284696	Diadema antillarum	105358	Echinodermata	other_Eukaryota	44.3	0.00514	NR	XP_071499350.1	105358	g41309	i0	42.2	2.98404255319149	64	34	98.9	2	186	1	114	176	XP_071499350.1 uncharacterized protein [Diadema antillarum]	diamond	561	44.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
27938715	27938715	PRJNA807685_P_NODE_55765_length_164_cov_1.007874_g54692_i0	PRJNA807685	55765	164	1.007874	1.65291336	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	58.9	2.47e-8	NR	XP_063960129.1	7653	g54692	i0	48.9	1.68292682926829	47	24	86	0	19	159	730	776	XP_063960129.1 zinc finger protein 91-like [Lytechinus pictus]	diamond	276	58.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
29778710	29778710	PRJNA807685_P_NODE_23271_length_280_cov_2.390947_g22198_i0	PRJNA807685	23271	280	2.390947	6.6946516	Metazoa	33208	Echinodermata	other_Eukaryota	102	8.489999999999999e-23	NR	XP_001199878.3	7668	g22198	i0	54.5	4.81071428571429	88	39	94.3	1	7	270	299	385	XP_001199878.3 uncharacterized protein LOC763787 isoform X1 [Strongylocentrotus purpuratus]	diamond	1347	102	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
31737970	31737970	PRJNA807685_P_NODE_54497_length_165_cov_2.359375_g53424_i0	PRJNA807685	54497	165	2.359375	3.89296875	Metazoa	33208	Echinodermata	other_Eukaryota	43.5	0.00541	NR	XP_033647943.1	7604	g53424	i0	34	4.8	53	33	92.7	1	3	155	99	151	XP_033647943.1 uncharacterized protein LOC117307331 [Asterias rubens]	diamond	792	43.9	0.990888382687927	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);;