metadata: contig_metadata: 19 rows where bioproject = "PRJEB673" and tax

19 rows where bioproject = "PRJEB673" and tax_phylum = "Chordata"

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
995299	995299	PRJEB673_P_NODE_13001_length_150_cov_1.391304_g12652_i0	PRJEB673	13001	150	1.391304	2.086956	Vulpes	9625	Chordata	Chordata	78.7	2.02e-10	NTclustered	gi\|1435549343\|ref\|XM_025991200.1\|	9627	g12652	i0	80.769	12.6666666666667	104	16	68	4	32	133	222	323	PREDICTED: Vulpes vulpes 60S ribosomal protein L30-like (LOC112914198), mRNA	blastn	1900	78.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Vulpes	Vulpes vulpes
2684946	2684946	PRJEB673_P_NODE_10323_length_176_cov_1.666667_g9974_i0	PRJEB673	10323	176	1.666667	2.93333392	Lethenteron reissneri	7753	Chordata	Chordata	178	2.35e-40	NTclustered	gi\|2635851083\|ref\|XM_061560508.1\|	7753	g9974	i0	86.792	70.2727272727273	159	21	90	0	1	159	252	410	PREDICTED: Lethenteron reissneri ribosomal protein S9 (RPS9), mRNA	blastn	12368	178	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
5237423	5237423	PRJEB673_P_NODE_11925_length_157_cov_1.811475_g11576_i0	PRJEB673	11925	157	1.811475	2.84401575	Mus musculus	10090	Chordata	Chordata	52.8	0.013	NTclustered	gi\|1039744595\|ref\|XR_001780889.1\|	10090	g11576	i0	100	0.356687898089172	28	0	18	0	112	139	355	328	PREDICTED: Mus musculus predicted gene, 30127 (Gm30127), ncRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
5237510	5237510	PRJEB673_P_NODE_9685_length_190_cov_1.290323_g9336_i0	PRJEB673	9685	190	1.290323	2.4516137	Xenopus laevis	8355	Chordata	Chordata	52.8	0.016	NTclustered	gi\|2038222965\|ref\|XM_041565031.1\|	8355	g9336	i0	100	2.50526315789474	28	0	15	0	148	175	5263	5290	PREDICTED: Xenopus laevis myelin transcription factor 1-like protein (LOC108718228), transcript variant X5, mRNA	blastn	476	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
8648449	8648449	PRJEB673_P_NODE_7847_length_305_cov_1.974074_g7498_i0	PRJEB673	7847	305	1.974074	6.0209257	Lacertidae	8522	Chordata	Chordata	52.8	0.028	NTclustered	gi\|1622176963\|ref\|XM_028710289.1\|	64176	g7498	i0	100	1.00983606557377	28	0	9	0	190	217	201	174	PREDICTED: Podarcis muralis beta-keratin-related protein-like (LOC114586635), mRNA	blastn	308	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Podarcis	Podarcis muralis
9062218	9062218	PRJEB673_P_NODE_5688_length_371_cov_1.633929_g5339_i0	PRJEB673	5688	371	1.633929	6.06187659	Lutra lutra	9657	Chordata	Chordata	99.8	8.81e-22	NR	XP_047569650.1	9657	g5339	i0	51.4	2.54716981132075	105	44	81.7	3	367	65	221	322	XP_047569650.1 60S ribosomal protein L3-like isoform X4 [Lutra lutra]	diamond	945	99.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Lutra	Lutra lutra
10337906	10337906	PRJEB673_P_NODE_10789_length_169_cov_1.029851_g10440_i0	PRJEB673	10789	169	1.029851	1.74044819	Chrysemys picta	8479	Chordata	Chordata	108	2.97e-19	NTclustered	gi\|2739604710\|ref\|XM_065551444.1\|	8478	g10440	i0	78.981	1.09467455621302	157	33	93	0	11	167	442	286	PREDICTED: Chrysemys picta bellii ADP ribosylation factor 5 (ARF5), mRNA	blastn	185	108	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Emydidae	Chrysemys	Chrysemys picta
14163274	14163274	PRJEB673_P_NODE_12972_length_150_cov_1.434783_g12623_i0	PRJEB673	12972	150	1.434783	2.1521745	Ranitomeya imitator	111125	Chordata	Chordata	89.8	9.31e-14	NTclustered	gi\|2851959547\|ref\|XM_069731569.1\|	111125	g12623	i0	88	2.98666666666667	75	9	50	0	76	150	1789	1715	PREDICTED: Ranitomeya imitator V-type proton ATPase subunit d 2 (LOC138642939), mRNA	blastn	448	89.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
17986456	17986456	PRJEB673_P_NODE_12235_length_155_cov_1.333333_g11886_i0	PRJEB673	12235	155	1.333333	2.06666615	Spinus spinus	160760	Chordata	Chordata	52.8	0.013	NTclustered	gi\|2917663466\|emb\|OZ228753.1\|	160760	g11886	i0	100	0.361290322580645	28	0	18	0	38	65	37205149	37205122	Spinus spinus genome assembly, chromosome: 5	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Spinus	Spinus spinus
23086656	23086656	PRJEB673_P_NODE_11439_length_161_cov_1.587302_g11090_i0	PRJEB673	11439	161	1.587302	2.55555622	Erinaceus europaeus	9365	Chordata	Chordata	56.5	0.001	NTclustered	gi\|2591557184\|ref\|XM_060201429.1\|	9365	g11090	i0	94.595	0.919254658385093	37	1	22	1	72	107	2229	2193	PREDICTED: Erinaceus europaeus kirre like nephrin family adhesion molecule 1 (KIRREL1), transcript variant X3, mRNA	blastn	148	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Eulipotyphla	Erinaceidae	Erinaceus	Erinaceus europaeus
23947823	23947823	PRJEB673_P_NODE_6739_length_334_cov_2.311037_g6390_i0	PRJEB673	6739	334	2.311037	7.71886358	Rodentia	9989	Chordata	Chordata	54.7	0.009	NTclustered	gi\|2599575189\|ref\|XM_060385522.1\|	10047	g6390	i0	100	0.955089820359281	29	0	9	0	89	117	613	585	PREDICTED: Meriones unguiculatus phospholipid scramblase 4 (Plscr4), transcript variant X3, mRNA	blastn	319	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Meriones	Meriones unguiculatus
24360697	24360697	PRJEB673_P_NODE_2260_length_648_cov_1.761827_g1983_i0	PRJEB673	2260	648	1.761827	11.41663896	Opisthokonta	33154	Chordata	Chordata	217	5.3399999999999985e-68	NR	AAN73380.1	7740	g1983	i0	67.4	25.6296296296296	184	51	81.9	2	3	533	12	193	AAN73380.1 ribosomal protein L19, partial [Branchiostoma lanceolatum]	diamond	16608	218	0.995412844036697	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma lanceolatum
26907550	26907550	PRJEB673_P_NODE_9062_length_215_cov_1.227778_g8713_i0	PRJEB673	9062	215	1.227778	2.6397227	Ovis aries	9940	Chordata	Chordata	44.3	0.00524	NR	XDA90976.1	9940	g8713	i0	50	2.4	44	22	61.4	0	134	3	96	139	XDA90976.1 hypothetical protein R6Z07_020896 [Ovis aries]	diamond	516	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Ovis	Ovis aries
27152891	27152891	PRJEB673_P_NODE_10242_length_178_cov_0.993007_g9893_i0	PRJEB673	10242	178	0.993007	1.76755246	Chordata	7711	Chordata	Chordata	99.8	2.85e-24	NR	CAG5113179.1	34765	g9893	i0	79.7	36.7078651685393	59	12	99.4	0	1	177	69	127	CAG5113179.1 Oidioi.mRNA.OKI2018_I69.chr2.g7311.t1.cds [Oikopleura dioica]	diamond	6534	100	0.998	Eukaryota	Opisthokonta	Metazoa	Chordata	Appendicularia	Copelata	Oikopleuridae	Oikopleura	Oikopleura dioica
28700841	28700841	PRJEB673_P_NODE_12827_length_151_cov_1.379310_g12478_i0	PRJEB673	12827	151	1.37931	2.0827581	root	1	Root_unresolved	Root_unresolved	50.1	2.77e-5	NR	XP_032814129.1	7757	g12478	i0	71.4	1.54966887417219	28	7	53.6	1	1	81	90	117	XP_032814129.1 CUB and zona pellucida-like domain-containing protein 1 [Petromyzon marinus]	diamond	234	50.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Petromyzon	Petromyzon marinus
29907918	29907918	PRJEB673_P_NODE_6191_length_352_cov_1.473186_g5842_i0	PRJEB673	6191	352	1.473186	5.18561472	Pteruthius melanotis	357074	Chordata	Chordata	42.7	0.032	NR	NXY03596.1	357074	g5842	i0	46.8	0.767045454545455	47	22	37.5	1	308	177	1	47	NXY03596.1 PLAC8 protein [Pteruthius melanotis]	diamond	270	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Timaliidae	Pteruthius	Pteruthius melanotis
30627103	30627103	PRJEB673_P_NODE_9933_length_184_cov_1.342282_g9584_i0	PRJEB673	9933	184	1.342282	2.46979888	Metazoa	33208	Chordata	Chordata	42	0.0326	NR	XP_061277822.1	9906	g9584	i0	33.9	4.04347826086957	62	37	96.2	2	180	4	46	106	XP_061277822.1 adhesion G protein-coupled receptor E2-like isoform X3 [Bos javanicus]	diamond	744	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
32145014	32145014	PRJEB673_P_NODE_11938_length_157_cov_1.639344_g11589_i0	PRJEB673	11938	157	1.639344	2.57377008	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	57.8	4.78e-8	NR	XP_045756899.1	9716	g11589	i0	61.4	39.9363057324841	44	17	84.1	0	136	5	29	72	XP_045756899.1 proteasome subunit alpha type-3 isoform X1 [Mirounga angustirostris]	diamond	6270	58.2	0.993127147766323	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Phocidae	Mirounga	Mirounga angustirostris
32808162	32808162	PRJEB673_P_NODE_11200_length_164_cov_0.930233_g10851_i0	PRJEB673	11200	164	0.930233	1.52558212	root	1	Root_unresolved	Root_unresolved	66.2	6.05e-11	NR	BAU16176.1	8330	g10851	i0	59.3	10.9207317073171	54	22	98.8	0	1	162	130	183	BAU16176.1 pepsinogen A1 [Cynops pyrrhogaster]	diamond	1791	66.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Cynops	Cynops pyrrhogaster

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