metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA541476" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA541476" 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
4946677	4946677	PRJNA541476_P_NODE_1244_length_1066_cov_13.381672_g1102_i0	PRJNA541476	1244	1066	13.381672	142.64862352	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	289	1.61e-93	NR	XP_033118288.1	1529436	g1102	i0	60.4	2.65947467166979	235	93	66.1	0	78	782	9	243	XP_033118288.1 60S ribosomal protein L7-like isoform X2 [Anneissia japonica]	diamond	2835	289	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
22185187	22185187	PRJNA541476_P_NODE_13078_length_325_cov_1.861111_g12872_i0	PRJNA541476	13078	325	1.861111	6.04861075	Opisthokonta	33154	Echinodermata	other_Eukaryota	129	3.19e-33	NR	XP_033628088.1	7604	g12872	i0	60	7.02461538461538	110	40	98.8	2	3	323	49	157	XP_033628088.1 4-hydroxyphenylpyruvate dioxygenase-like [Asterias rubens]	diamond	2283	130	0.992307692307692	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
26839855	26839855	PRJNA541476_P_NODE_21841_length_274_cov_1.890547_g21635_i0	PRJNA541476	21841	274	1.890547	5.18009878	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	55.5	1.69e-6	NR	PIK37058.1	307972	g21635	i0	41.5	5.81386861313869	53	27	58	1	108	266	212	260	PIK37058.1 putative tyrosine-protein kinase [Apostichopus japonicus]	diamond	1593	55.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
26856656	26856656	PRJNA541476_P_NODE_7161_length_422_cov_2.212034_g6957_i0	PRJNA541476	7161	422	2.212034	9.33478348	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	49.3	7.56e-4	NR	PIK57380.1	307972	g6957	i0	63.6	0.504739336492891	33	12	23.5	0	422	324	184	216	PIK57380.1 hypothetical protein BSL78_05707 [Apostichopus japonicus]	diamond	213	49.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
28071768	28071768	PRJNA541476_P_NODE_20685_length_279_cov_1.689320_g20479_i0	PRJNA541476	20685	279	1.68932	4.7132028	Lytechinus	7652	Echinodermata	other_Eukaryota	72.4	1.44e-12	NR	XP_054751811.2	7653	g20479	i0	41.4	2.87096774193548	87	41	93.5	2	10	270	101	177	XP_054751811.2 uncharacterized protein LOC129257501 [Lytechinus pictus]	diamond	801	72.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
28783043	28783043	PRJNA541476_P_NODE_26047_length_259_cov_1.908602_g25841_i0	PRJNA541476	26047	259	1.908602	4.94327918	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	45.1	0.00678	NR	XP_030851438.1	7668	g25841	i0	35.1	0.857142857142857	74	45	85.7	1	36	257	571	641	XP_030851438.1 serine/threonine-protein kinase Nek8 [Strongylocentrotus purpuratus]	diamond	222	45.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
29177148	29177148	PRJNA541476_P_NODE_17089_length_296_cov_1.852018_g16883_i0	PRJNA541476	17089	296	1.852018	5.48197328	Metazoa	33208	Echinodermata	other_Eukaryota	140	1.8999999999999995e-38	NR	XP_041465397.1	7654	g16883	i0	59.8	2.68581081081081	97	39	98.3	0	291	1	62	158	XP_041465397.1 cathepsin B-like [Lytechinus variegatus]	diamond	795	140	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
30235849	30235849	PRJNA541476_P_NODE_632_length_1409_cov_4.254491_g539_i0	PRJNA541476	632	1409	4.254491	59.94577819	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	139	8.82e-33	NR	PIK62982.1	307972	g539	i0	31.3	0.960255500354862	313	192	62.6	9	43	924	6	314	PIK62982.1 hypothetical protein BSL78_00109 [Apostichopus japonicus]	diamond	1353	139	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
31057674	31057674	PRJNA541476_P_NODE_12055_length_335_cov_2.946565_g11849_i0	PRJNA541476	12055	335	2.946565	9.87099275	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	72.8	3.23e-12	NR	KAJ8019560.1	206669	g11849	i0	39.4	1.77313432835821	99	57	87.8	2	32	325	1230	1326	KAJ8019560.1 A disintegrin and metalloproteinase with thrombospondin motifs 9 [Holothuria leucospilota]	diamond	594	72.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
32607045	32607045	PRJNA541476_P_NODE_12520_length_330_cov_2.638132_g12314_i0	PRJNA541476	12520	330	2.638132	8.7058356	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	68.9	6.95e-11	NR	KAJ8046378.1	206669	g12314	i0	43.2	2.37272727272727	81	46	73.6	0	243	1	951	1031	KAJ8046378.1 DNA repair protein complementing XP-C cells-like [Holothuria leucospilota]	diamond	783	68.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota

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