metadata: contig_metadata: 4 rows where bioproject = "PRJNA451191", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA451191", tax_clade = "Opisthokonta" 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
28023725	28023725	PRJNA451191_P_NODE_50885_length_206_cov_0.896552_g50614_i0	PRJNA451191	50885	206	0.896552	1.84689712	Diadema antillarum	105358	Echinodermata	other_Eukaryota	42.4	0.024	NR	XP_071506736.1	105358	g50614	i0	52.8	0.524271844660194	36	17	52.4	0	128	21	88	123	XP_071506736.1 uncharacterized protein B0403.1-like [Diadema antillarum]	diamond	108	42.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
29113498	29113498	PRJNA451191_P_NODE_33248_length_247_cov_1.397849_g32977_i0	PRJNA451191	33248	247	1.397849	3.45268703	Metazoa	33208	Echinodermata	other_Eukaryota	44.7	0.00808	NR	XP_071500006.1	105358	g32977	i0	47.4	4.80971659919028	38	20	46.2	0	119	6	569	606	XP_071500006.1 uncharacterized protein [Diadema antillarum]	diamond	1188	44.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
29886685	29886685	PRJNA451191_P_NODE_27211_length_272_cov_2.464455_g26940_i0	PRJNA451191	27211	272	2.464455	6.7033176	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	48.9	3.59e-4	NR	KAJ8028011.1	206669	g26940	i0	39.1	0.761029411764706	69	38	72.8	2	2	199	713	780	KAJ8028011.1 hypothetical protein HOLleu_30132 [Holothuria leucospilota]	diamond	207	48.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
32668173	32668173	PRJNA451191_P_NODE_20980_length_313_cov_1.547619_g20709_i0	PRJNA451191	20980	313	1.547619	4.84404747	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	66.6	3.67e-10	NR	XP_041480387.1	7654	g20709	i0	60	0.527156549520767	55	20	50.8	1	208	50	1914	1968	XP_041480387.1 uncharacterized protein LOC121427880 [Lytechinus variegatus]	diamond	165	66.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus

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