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

5 rows where bioproject = "PRJNA1115053", tax_kingdom = "Metazoa" and tax_phylum = "Hemichordata"

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_family	tax_genus	tax_species
11705934	11705934	PRJNA1115053_S_NODE_30610_length_398_cov_40.923944_g28798_i0	PRJNA1115053	30610	398	40.923944	162.87729712	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	62.1	6.33e-5	NTclustered	gi\|154426342\|gb\|AC206145.3\|	10224	g28798	i0	91.304	7.36934673366834	46	2	12	2	1	46	88433	88476	Saccoglossus kowalevskii BAC CUGI_SK_BA 001A7 (Clemson University Genomics SSK_Ba library (Acorn worm, Saccoglossus kowalevskii)) complete sequence	blastn	2933	62.1	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
29310044	29310044	PRJNA1115053_S_NODE_17189_length_484_cov_1.804989_g15403_i0	PRJNA1115053	17189	484	1.804989	8.73614676	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	55.8	1.26e-5	NR	XP_006826086.1	10224	g15403	i0	44.4	0.390495867768595	63	35	39	0	192	380	1098	1160	XP_006826086.1 PREDICTED: uncharacterized protein LOC102808992 [Saccoglossus kowalevskii]	diamond	189	55.8	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
29404838	29404838	PRJNA1115053_S_NODE_194449_length_196_cov_2.052288_g192632_i0	PRJNA1115053	194449	196	2.052288	4.02248448	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	54.3	1.71e-6	NR	XP_006826086.1	10224	g192632	i0	56.4	0.596938775510204	39	17	59.7	0	193	77	1153	1191	XP_006826086.1 PREDICTED: uncharacterized protein LOC102808992 [Saccoglossus kowalevskii]	diamond	117	54.3	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
31141895	31141895	PRJNA1115053_S_NODE_50935_length_334_cov_4.817869_g49118_i0	PRJNA1115053	50935	334	4.817869	16.09168246	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	68.2	1.29e-10	NR	XP_006825658.1	10224	g49118	i0	51.7	9.29640718562874	60	29	53.9	0	182	3	87	146	XP_006825658.1 PREDICTED: uncharacterized protein LOC102806397 [Saccoglossus kowalevskii]	diamond	3105	68.6	0.994169096209913	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
32439464	32439464	PRJNA1115053_S_NODE_170419_length_208_cov_1.163636_g168602_i0	PRJNA1115053	170419	208	1.163636	2.42036288	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	50.8	3.3e-5	NR	XP_006820893.1	10224	g168602	i0	51	1.47115384615385	51	24	72.1	1	183	34	129	179	XP_006820893.1 PREDICTED: uncharacterized protein LOC102808110 [Saccoglossus kowalevskii]	diamond	306	50.8	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii

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