metadata: contig_metadata: 15 rows where bioproject = "PRJNA520845" and tax

15 rows where bioproject = "PRJNA520845" 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
3043627	3043627	PRJNA520845_P_NODE_65523_length_459_cov_5.266839_g64024_i0	PRJNA520845	65523	459	5.266839	24.17479101	Ptychodera flava	63121	Hemichordata	other_Eukaryota	267	1.46e-66	NTclustered	gi\|2875711234\|ref\|XM_070686233.1\|	63121	g64024	i0	89.904	43.4945533769063	208	19	45	2	1	207	1289	1495	PREDICTED: Ptychodera flava tubulin alpha-1A chain-like (LOC139121399), mRNA	blastn	19964	267	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
4940216	4940216	PRJNA520845_P_NODE_60584_length_479_cov_1.199507_g59088_i0	PRJNA520845	60584	479	1.199507	5.74563853	Metazoa	33208	Hemichordata	other_Eukaryota	326	2.49e-84	NTclustered	gi\|2875693509\|ref\|XM_070680034.1\|	63121	g59088	i0	78.992	89.705636743215	476	100	99	0	2	477	711	236	PREDICTED: Ptychodera flava tubulin beta chain-like (LOC139117161), mRNA	blastn	42969	326	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
8145707	8145707	PRJNA520845_P_NODE_67447_length_453_cov_1.278947_g65948_i0	PRJNA520845	67447	453	1.278947	5.79362991	Ptychodera flava	63121	Hemichordata	other_Eukaryota	366	1.3799999999999995e-96	NTclustered	gi\|2875693509\|ref\|XM_070680034.1\|	63121	g65948	i0	81.716	95.9602649006623	443	78	97	3	6	446	947	506	PREDICTED: Ptychodera flava tubulin beta chain-like (LOC139117161), mRNA	blastn	43470	366	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
14521827	14521827	PRJNA520845_P_NODE_77552_length_422_cov_0.882521_g76053_i0	PRJNA520845	77552	422	0.882521	3.72423862	Ptychodera flava	63121	Hemichordata	other_Eukaryota	54.7	0.011	NTclustered	gi\|2875662737\|ref\|XM_070716283.1\|	63121	g76053	i0	96.97	0.0781990521327014	33	0	8	1	240	271	1315	1283	PREDICTED: Ptychodera flava T-box transcription factor TBX20-like (LOC139145251), mRNA	blastn	33	54.7	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
17069836	17069836	PRJNA520845_P_NODE_65014_length_461_cov_2.822165_g63515_i0	PRJNA520845	65014	461	2.822165	13.01018065	Ptychodera flava	63121	Hemichordata	other_Eukaryota	169	4.26e-37	NTclustered	gi\|2875658907\|ref\|XM_070714316.1\|	63121	g63515	i0	80.734	1.96529284164859	218	40	47	2	239	455	140	356	PREDICTED: Ptychodera flava histone H2B, gonadal-like (LOC139143767), mRNA	blastn	906	169	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
26950626	26950626	PRJNA520845_P_NODE_78702_length_418_cov_3.582609_g77203_i0	PRJNA520845	78702	418	3.582609	14.97530562	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	157	5.92e-46	NR	XP_002741821.1	10224	g77203	i0	71.2	47.7631578947368	104	30	74.6	0	314	3	12	115	XP_002741821.1 PREDICTED: 60S ribosomal protein L11-like [Saccoglossus kowalevskii]	diamond	19965	157	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
27740971	27740971	PRJNA520845_P_NODE_196424_length_265_cov_0.927083_g194925_i0	PRJNA520845	196424	265	0.927083	2.45676995	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	123	2.3e-30	NR	XP_006816599.1	10224	g194925	i0	67	0.99622641509434	88	26	99.6	1	2	265	416	500	XP_006816599.1 PREDICTED: LOW QUALITY PROTEIN: thimet oligopeptidase-like [Saccoglossus kowalevskii]	diamond	264	123	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
27835241	27835241	PRJNA520845_P_NODE_214324_length_251_cov_0.865169_g212825_i0	PRJNA520845	214324	251	0.865169	2.17157419	Ptychodera flava	63121	Hemichordata	other_Eukaryota	65.1	5.54e-10	NR	XP_070540415.1	63121	g212825	i0	40.5	0.944223107569721	79	45	94.4	1	2	238	696	772	XP_070540415.1 protein-glucosylgalactosylhydroxylysine glucosidase-like [Ptychodera flava]	diamond	237	65.1	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
27976939	27976939	PRJNA520845_P_NODE_201665_length_260_cov_1.641711_g200166_i0	PRJNA520845	201665	260	1.641711	4.2684486	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	134	2.27e-38	NR	XP_070581486.1	63121	g200166	i0	75.6	39.0230769230769	86	21	99.2	0	2	259	34	119	XP_070581486.1 late histone H2A.2.2-like [Ptychodera flava]	diamond	10146	134	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
28450781	28450781	PRJNA520845_P_NODE_195106_length_266_cov_1.191710_g193607_i0	PRJNA520845	195106	266	1.19171	3.1699486	Metazoa	33208	Hemichordata	other_Eukaryota	70.5	5.55e-13	NR	XP_006820804.1	10224	g193607	i0	56.7	2.03007518796993	60	24	67.7	2	265	86	93	150	XP_006820804.1 PREDICTED: ras-related protein Rab-7a-like [Saccoglossus kowalevskii]	diamond	540	70.5	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
29066836	29066836	PRJNA520845_P_NODE_105648_length_362_cov_1.290657_g104149_i0	PRJNA520845	105648	362	1.290657	4.67217834	Ptychodera flava	63121	Hemichordata	other_Eukaryota	69.3	1.88e-11	NR	XP_070535390.1	63121	g104149	i0	52.2	0.74585635359116	90	38	73.8	2	346	80	20	105	XP_070535390.1 chromatin target of PRMT1 protein-like isoform X2 [Ptychodera flava]	diamond	270	69.3	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava
29303084	29303084	PRJNA520845_P_NODE_71809_length_438_cov_2.747945_g70310_i0	PRJNA520845	71809	438	2.747945	12.0359991	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	193	6.070000000000001e-59	NR	XP_006821611.1	10224	g70310	i0	62.9	42.2260273972603	143	51	97.9	1	6	434	13	153	XP_006821611.1 PREDICTED: 40S ribosomal protein S3a-like [Saccoglossus kowalevskii]	diamond	18495	193	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
30440318	30440318	PRJNA520845_P_NODE_257753_length_243_cov_0.905882_g256254_i0	PRJNA520845	257753	243	0.905882	2.20129326	Metazoa	33208	Hemichordata	other_Eukaryota	72.4	1.38e-12	NR	XP_006811167.1	10224	g256254	i0	82.1	1.44444444444444	39	7	48.1	0	1	117	1277	1315	XP_006811167.1 PREDICTED: splicing factor 3B subunit 1-like [Saccoglossus kowalevskii]	diamond	351	72.4	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
32732571	32732571	PRJNA520845_P_NODE_207400_length_255_cov_2.659341_g205901_i0	PRJNA520845	207400	255	2.659341	6.78131955	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	108	4.15e-25	NR	XP_006812505.1	10224	g205901	i0	63.1	0.988235294117647	84	31	98.8	0	254	3	1567	1650	XP_006812505.1 PREDICTED: bifunctional glutamate/proline--tRNA ligase-like [Saccoglossus kowalevskii]	diamond	252	108	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
32873563	32873563	PRJNA520845_P_NODE_168520_length_287_cov_1.079439_g167021_i0	PRJNA520845	168520	287	1.079439	3.09798993	Opisthokonta	33154	Hemichordata	other_Eukaryota	86.3	1.9e-17	NR	XP_070542938.1	63121	g167021	i0	52.3	10.6202090592334	88	40	92	2	265	2	70	155	XP_070542938.1 alpha-methylacyl-CoA racemase-like [Ptychodera flava]	diamond	3048	86.7	0.995386389850058	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta	Ptychoderidae	Ptychodera	Ptychodera flava

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