metadata: contig_metadata: 7 rows where bioproject = "PRJNA448207", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA448207", 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
439042	439042	PRJNA448207_S_NODE_3661_length_246_cov_7.728324_g3650_i0	PRJNA448207	3661	246	7.728324	19.01167704	Diadema antillarum	105358	Echinodermata	other_Eukaryota	145	3.56e-30	NTclustered	gi\|2919551852\|ref\|XM_071622851.1\|	105358	g3650	i0	90.09	52.5609756097561	111	11	45	0	1	111	233	123	PREDICTED: Diadema antillarum late histone H2B.L3-like (LOC139710927), mRNA	blastn	12930	145	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
27897192	27897192	PRJNA448207_P_NODE_21225_length_279_cov_1.179612_g21062_i0	PRJNA448207	21225	279	1.179612	3.29111748	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	137	9.61e-36	NR	XP_033115857.1	1529436	g21062	i0	65.9	1.96774193548387	91	31	97.8	0	1	273	273	363	XP_033115857.1 aarF domain-containing protein kinase 1-like [Anneissia japonica]	diamond	549	137	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
28244454	28244454	PRJNA448207_P_NODE_6066_length_491_cov_1.023923_g5904_i0	PRJNA448207	6066	491	1.023923	5.02746193	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	152	2.18e-39	NR	XP_033127122.1	1529436	g5904	i0	56	2.21181262729124	134	50	76.4	1	491	117	1292	1425	XP_033127122.1 transcriptional regulator ATRX-like [Anneissia japonica]	diamond	1086	152	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
30850573	30850573	PRJNA448207_S_NODE_3014_length_265_cov_2.020833_g3003_i0	PRJNA448207	3014	265	2.020833	5.35520745	Metazoa	33208	Echinodermata	other_Eukaryota	52.8	1.47e-5	NR	XP_041473649.1	7654	g3003	i0	47.9	8.2188679245283	48	25	54.3	0	257	114	1020	1067	XP_041473649.1 uncharacterized protein LOC121422569 [Lytechinus variegatus]	diamond	2178	52.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
31118457	31118457	PRJNA448207_P_NODE_19955_length_288_cov_1.074419_g19792_i0	PRJNA448207	19955	288	1.074419	3.09432672	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	45.4	0.00738	NR	PIK36269.1	307972	g19792	i0	48.8	0.864583333333333	41	19	42.7	1	9	131	628	666	PIK36269.1 hypothetical protein BSL78_26896 [Apostichopus japonicus]	diamond	249	45.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
31767409	31767409	PRJNA448207_P_NODE_13677_length_341_cov_1.410448_g13514_i0	PRJNA448207	13677	341	1.410448	4.80962768	Metazoa	33208	Echinodermata	other_Eukaryota	66.2	6.5e-10	NR	XP_033102632.1	1529436	g13514	i0	37	9.03519061583578	108	63	92.4	2	27	341	29	134	XP_033102632.1 protein aurora borealis-like [Anneissia japonica]	diamond	3081	66.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
32574076	32574076	PRJNA448207_S_NODE_2739_length_277_cov_1.083333_g2728_i0	PRJNA448207	2739	277	1.083333	3.00083241	Diadema antillarum	105358	Echinodermata	other_Eukaryota	87.4	2.2e-18	NR	XP_071482165.1	105358	g2728	i0	45.7	4.96028880866426	92	50	99.6	0	277	2	87	178	XP_071482165.1 nuclear protein localization protein 4 homolog, partial [Diadema antillarum]	diamond	1374	87.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum

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