metadata: contig_metadata: 21 rows where bioproject = "PRJEB64798" and tax

21 rows where bioproject = "PRJEB64798" 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_order	tax_family	tax_genus	tax_species
2678984	2678984	PRJEB64798_P_NODE_38223_length_319_cov_67.533333_g36463_i0	PRJEB64798	38223	319	67.533333	215.43133227	Harrimania kupfferi	1171614	Hemichordata	other_Eukaryota	99	3.79e-16	NTclustered	gi\|2292923489\|gb\|OP331330.1\|	1171614	g36463	i0	92.754	20.2163009404389	69	4	22	1	4	72	340	273	Harrimania kupfferi voucher XZ5532 large subunit ribosomal RNA gene, partial sequence	blastn	6449	99	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Harrimaniidae	Harrimania	Harrimania kupfferi
5230175	5230175	PRJEB64798_P_NODE_178285_length_175_cov_2.944444_g176519_i0	PRJEB64798	178285	175	2.944444	5.152777	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	56.5	0.001	NTclustered	gi\|585679356\|ref\|XR_438416.1\|	10224	g176519	i0	100	0.342857142857143	30	0	17	0	6	35	2040	2011	PREDICTED: Saccoglossus kowalevskii nipped-B-like protein-like (LOC100366412), transcript variant X2, misc_RNA	blastn	60	56.5	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
16295821	16295821	PRJEB64798_P_NODE_200113_length_167_cov_4.771186_g198347_i0	PRJEB64798	200113	167	4.771186	7.96788062	Metazoa	33208	Hemichordata	other_Eukaryota	89.8	1.07e-13	NTclustered	gi\|2875687517\|ref\|XM_070676966.1\|	63121	g198347	i0	89.855	3.59281437125748	69	7	41	0	91	159	2330	2398	PREDICTED: Ptychodera flava polyadenylate-binding protein 1-A-like (LOC139115081), mRNA	blastn	600	89.8	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
16705674	16705674	PRJEB64798_P_NODE_44394_length_295_cov_12.264228_g42629_i0	PRJEB64798	44394	295	12.264228	36.1794726	Cephalodiscus gracilis	117499	Hemichordata	other_Eukaryota	93.5	1.61e-14	NTclustered	gi\|11494221\|gb\|AF212172.1\|AF212172	117499	g42629	i0	83.168	18.535593220339	101	16	34	1	194	293	4186	4086	Cephalodiscus gracilis 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	5468	93.5	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Pterobranchia	Cephalodiscida	Cephalodiscidae	Cephalodiscus	Cephalodiscus gracilis
19253891	19253891	PRJEB64798_P_NODE_231396_length_158_cov_4.256881_g229630_i0	PRJEB64798	231396	158	4.256881	6.72587198	Ptychodera flava	63121	Hemichordata	other_Eukaryota	57.4	6.64e-8	NR	XP_070541844.1	63121	g229630	i0	71.1	5.24050632911392	45	13	85.4	0	147	13	216	260	XP_070541844.1 small ribosomal subunit protein eS6-like [Ptychodera flava]	diamond	828	57.4	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
23080595	23080595	PRJEB64798_P_NODE_27339_length_376_cov_13.464832_g25584_i0	PRJEB64798	27339	376	13.464832	50.62776832	Cephalodiscus gracilis	117499	Hemichordata	other_Eukaryota	87.9	9.81e-13	NTclustered	gi\|11494221\|gb\|AF212172.1\|AF212172	117499	g25584	i0	82.178	14.343085106383	101	17	27	1	275	374	4186	4086	Cephalodiscus gracilis 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	5393	87.9	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Pterobranchia	Cephalodiscida	Cephalodiscidae	Cephalodiscus	Cephalodiscus gracilis
26963382	26963382	PRJEB64798_P_NODE_212982_length_164_cov_1.426087_g211216_i0	PRJEB64798	212982	164	1.426087	2.33878268	Metazoa	33208	Hemichordata	other_Eukaryota	61.6	2.71e-9	NR	XP_070551288.1	63121	g211216	i0	61.5	1.90243902439024	52	18	95.1	1	7	162	8	57	XP_070551288.1 UDP-N-acetylglucosamine--dolichyl-phosphate N-acetylglucosaminephosphotransferase-like [Ptychodera flava]	diamond	312	62	0.993548387096774	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
27507919	27507919	PRJEB64798_P_NODE_18023_length_470_cov_3.862233_g16308_i0	PRJEB64798	18023	470	3.862233	18.1524951	Ptychodera flava	63121	Hemichordata	other_Eukaryota	80.9	6.12e-15	NR	XP_070559946.1	63121	g16308	i0	39.2	1.7936170212766	125	72	79.8	1	6	380	30	150	XP_070559946.1 calcium-activated chloride channel regulator family member 3-like [Ptychodera flava]	diamond	843	80.9	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
27729086	27729086	PRJEB64798_P_NODE_158564_length_184_cov_3.296296_g156798_i0	PRJEB64798	158564	184	3.296296	6.06518464	Ptychodera flava	63121	Hemichordata	other_Eukaryota	42	0.0332	NR	XP_070570129.1	63121	g156798	i0	36.1	0.994565217391304	61	37	99.5	2	184	2	130	188	XP_070570129.1 dnaJ homolog subfamily C member 13-like isoform X2 [Ptychodera flava]	diamond	183	42	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
28202133	28202133	PRJEB64798_P_NODE_158526_length_184_cov_3.422222_g156760_i0	PRJEB64798	158526	184	3.422222	6.29688848	Ptychodera flava	63121	Hemichordata	other_Eukaryota	52.4	3.47e-6	NR	XP_070581591.1	63121	g156760	i0	52	0.815217391304348	50	24	81.5	0	152	3	7	56	XP_070581591.1 apolipoprotein D-like [Ptychodera flava]	diamond	150	52.4	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
29717741	29717741	PRJEB64798_P_NODE_74710_length_223_cov_4.586207_g72945_i0	PRJEB64798	74710	223	4.586207	10.22724161	Ptychodera flava	63121	Hemichordata	other_Eukaryota	50.4	5.38e-5	NR	XP_070557394.1	63121	g72945	i0	37.7	1.88340807174888	69	30	92.8	4	15	221	8	63	XP_070557394.1 adhesion G protein-coupled receptor L3-like [Ptychodera flava]	diamond	420	50.4	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
30216315	30216315	PRJEB64798_P_NODE_34872_length_334_cov_5.284211_g33114_i0	PRJEB64798	34872	334	5.284211	17.64926474	Metazoa	33208	Hemichordata	other_Eukaryota	119	3.8699999999999995e-30	NR	XP_070541844.1	63121	g33114	i0	65.1	14.6317365269461	106	36	95.2	1	326	9	161	265	XP_070541844.1 small ribosomal subunit protein eS6-like [Ptychodera flava]	diamond	4887	119	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
30248240	30248240	PRJEB64798_P_NODE_148652_length_189_cov_3.400000_g146886_i0	PRJEB64798	148652	189	3.4	6.426	Metazoa	33208	Hemichordata	other_Eukaryota	48.1	2.21e-4	NR	XP_070557758.1	63121	g146886	i0	35	2.96825396825397	60	39	95.2	0	181	2	125	184	XP_070557758.1 LOW QUALITY PROTEIN: dipeptidyl peptidase 1-like [Ptychodera flava]	diamond	561	48.1	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
30350259	30350259	PRJEB64798_P_NODE_190672_length_170_cov_2.909091_g188906_i0	PRJEB64798	190672	170	2.909091	4.9454547	Ptychodera flava	63121	Hemichordata	other_Eukaryota	42.7	0.0141	NR	XP_070536963.1	63121	g188906	i0	38.9	1.97647058823529	54	32	95.3	1	4	165	501	553	XP_070536963.1 fibroblast growth factor receptor 4-like [Ptychodera flava]	diamond	336	42.7	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
30855170	30855170	PRJEB64798_P_NODE_171754_length_178_cov_2.364341_g169988_i0	PRJEB64798	171754	178	2.364341	4.20852698	Ptychodera flava	63121	Hemichordata	other_Eukaryota	57	1.47e-7	NR	XP_070545129.1	63121	g169988	i0	60	3.58988764044944	40	16	67.4	0	59	178	218	257	XP_070545129.1 uncharacterized protein [Ptychodera flava]	diamond	639	57	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
31163990	31163990	PRJEB64798_P_NODE_226275_length_160_cov_3.936937_g224509_i0	PRJEB64798	226275	160	3.936937	6.2990992	root	1	Root_unresolved	Root_unresolved	65.1	1.53e-10	NR	XP_070549843.1	63121	g224509	i0	55.8	3.76875	52	23	97.5	0	158	3	10011	10062	XP_070549843.1 uncharacterized protein [Ptychodera flava]	diamond	603	65.1	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
31701959	31701959	PRJEB64798_P_NODE_160277_length_183_cov_4.641791_g158511_i0	PRJEB64798	160277	183	4.6417909999999996	8.49447753	Hemichordata	10219	Hemichordata	other_Eukaryota	99.8	7.919999999999999e-23	NR	XP_006823776.1	10224	g158511	i0	74.6	2.90163934426229	59	15	96.7	0	6	182	367	425	XP_006823776.1 PREDICTED: protein dcd1A-like [Saccoglossus kowalevskii]	diamond	531	99.8	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
31796646	31796646	PRJEB64798_P_NODE_147557_length_189_cov_17.392857_g145791_i0	PRJEB64798	147557	189	17.392857	32.87249973	Metazoa	33208	Hemichordata	other_Eukaryota	72.8	4.45e-13	NR	XP_070539278.1	63121	g145791	i0	54.4	6.20634920634921	57	26	90.5	0	6	176	136	192	XP_070539278.1 nucleoside diphosphate kinase homolog 7-like isoform X2 [Ptychodera flava]	diamond	1173	73.2	0.994535519125683	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
31962006	31962006	PRJEB64798_P_NODE_78938_length_216_cov_7.574850_g77172_i0	PRJEB64798	78938	216	7.57485	16.361676	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	81.3	7.06e-16	NR	XP_006814192.1	10224	g77172	i0	57.8	1.77777777777778	64	22	88.9	2	208	17	1170	1228	XP_006814192.1 PREDICTED: SCO-spondin-like [Saccoglossus kowalevskii]	diamond	384	81.3	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
32688845	32688845	PRJEB64798_P_NODE_114340_length_209_cov_4.193750_g112574_i0	PRJEB64798	114340	209	4.19375	8.7649375	Ptychodera flava	63121	Hemichordata	other_Eukaryota	44.3	0.00706	NR	XP_070579639.1	63121	g112574	i0	59.4	1.03349282296651	32	10	41.6	1	206	120	363	394	XP_070579639.1 polycystin-1-related protein-like [Ptychodera flava]	diamond	216	44.3	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Ptychoderidae	Ptychodera	Ptychodera flava
32752179	32752179	PRJEB64798_P_NODE_83240_length_213_cov_7.115854_g81474_i0	PRJEB64798	83240	213	7.115854	15.15676902	Ptychodera flava	63121	Hemichordata	other_Eukaryota	77	6.82e-15	NR	XP_070543867.1	63121	g81474	i0	47.2	5.94366197183099	72	36	98.6	1	211	2	77	148	XP_070543867.1 serine protease hepsin-like [Ptychodera flava]	diamond	1266	77	1	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);;