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

5 rows where bioproject = "PRJNA1115053", 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
225596	225596	PRJNA1115053_S_NODE_236241_length_180_cov_1.401460_g234424_i0	PRJNA1115053	236241	180	1.40146	2.522628	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	73.1	1.17e-8	NTclustered	gi\|2289441675\|gb\|MW840372.1\|	7668	g234424	i0	78.195	1.01111111111111	133	16	67	7	45	164	640	508	Strongylocentrotus purpuratus isolate 331 Transposase-like gene, complete sequence	blastn	182	73.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
15526992	15526992	PRJNA1115053_S_NODE_185473_length_200_cov_2.140127_g183656_i0	PRJNA1115053	185473	200	2.140127	4.280254	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	63.9	8.03e-6	NTclustered	gi\|2289441675\|gb\|MW840372.1\|	7668	g183656	i0	82.5	1.1	80	7	38	5	30	105	916	840	Strongylocentrotus purpuratus isolate 331 Transposase-like gene, complete sequence	blastn	220	63.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
29593895	29593895	PRJNA1115053_S_NODE_156810_length_215_cov_2.290698_g154993_i0	PRJNA1115053	156810	215	2.290698	4.9250007	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	47.4	6.01e-4	NR	KAJ8049560.1	206669	g154993	i0	36.2	0.962790697674419	69	28	76.7	3	198	34	386	452	KAJ8049560.1 hypothetical protein HOLleu_02346 [Holothuria leucospilota]	diamond	207	47.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
30478882	30478882	PRJNA1115053_S_NODE_288753_length_164_cov_1.586777_g286936_i0	PRJNA1115053	288753	164	1.586777	2.60231428	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	55.5	4.14e-7	NR	PIK53570.1	307972	g286936	i0	51.9	1.97560975609756	54	26	98.8	0	1	162	412	465	PIK53570.1 putative RNA-directed DNA polymerase from mobile element jockey-like, partial [Apostichopus japonicus]	diamond	324	55.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
31932864	31932864	PRJNA1115053_S_NODE_151817_length_218_cov_2.382857_g150000_i0	PRJNA1115053	151817	218	2.382857	5.19462826	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	41.2	0.0274	NR	KAJ8043773.1	206669	g150000	i0	55.6	0.495412844036697	36	16	49.5	0	208	101	64	99	KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota]	diamond	108	41.2	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);;