metadata: contig_metadata: 35 rows where bioproject = "PRJNA675638" and tax

35 rows where bioproject = "PRJNA675638" 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
1924623	1924623	PRJNA675638_P_NODE_15262_length_184_cov_1.007407_g15065_i0	PRJNA675638	15262	184	1.007407	1.85362888	Fringilla coelebs	37598	Chordata	Chordata	54.7	0.004	NTclustered	gi\|2917613052\|emb\|OZ228692.1\|	37598	g15065	i0	100	0.315217391304348	29	0	16	0	90	118	69805682	69805654	Fringilla coelebs genome assembly, chromosome: 5	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Fringilla	Fringilla coelebs
3199495	3199495	PRJNA675638_S_NODE_6803_length_175_cov_1.214286_g6741_i0	PRJNA675638	6803	175	1.214286	2.1250005	Crotalus tigris	88082	Chordata	Chordata	52.8	0.015	NTclustered	gi\|1974302038\|ref\|XR_005554669.1\|	88082	g6741	i0	100	0.16	28	0	16	0	1	28	6886	6859	PREDICTED: Crotalus tigris ligand dependent nuclear receptor corepressor like (LCORL), transcript variant X3, misc_RNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Viperidae	Crotalus	Crotalus tigris
3720649	3720649	PRJNA675638_P_NODE_15963_length_180_cov_0.908397_g15766_i0	PRJNA675638	15963	180	0.908397	1.6351146	Lampetra	13103	Chordata	Chordata	54.7	0.004	NTclustered	gi\|2815006793\|emb\|OZ078596.2\|	7748	g15766	i0	96.875	3.86111111111111	32	1	18	0	149	180	8892445	8892414	Lampetra fluviatilis genome assembly, chromosome: 28	blastn	695	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
4476572	4476572	PRJNA675638_S_NODE_9064_length_162_cov_0.902655_g9002_i0	PRJNA675638	9064	162	0.902655	1.4623011	Vulpes lagopus	494514	Chordata	Chordata	250	4.45e-62	NTclustered	gi\|2044212914\|ref\|XR_005985650.1\|	494514	g9002	i0	94.512	2.02469135802469	164	6	100	2	1	162	21507	21669	PREDICTED: Vulpes lagopus uncharacterized LOC121482884 (LOC121482884), transcript variant X1, ncRNA	blastn	328	250	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Vulpes	Vulpes lagopus
5752163	5752163	PRJNA675638_S_NODE_1825_length_324_cov_0.894545_g1763_i0	PRJNA675638	1825	324	0.894545	2.8983258	Saccopteryx leptura	249018	Chordata	Chordata	54.7	0.008	NTclustered	gi\|2756211817\|ref\|XM_066357328.1\|	249018	g1763	i0	100	0.0895061728395062	29	0	9	0	65	93	1200	1228	PREDICTED: Saccopteryx leptura uncharacterized protein (LOC136386014), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Emballonuridae	Saccopteryx	Saccopteryx leptura
5752170	5752170	PRJNA675638_S_NODE_5885_length_187_cov_0.847826_g5823_i0	PRJNA675638	5885	187	0.847826	1.58543462	Lampetra fluviatilis	7748	Chordata	Chordata	63.9	7.39e-6	NTclustered	gi\|2805719359\|emb\|OZ078470.1\|	7748	g5823	i0	100	149.181818181818	34	0	18	0	154	187	5226036	5226069	Lampetra fluviatilis genome assembly, chromosome: 67	blastn	27897	63.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
9577137	9577137	PRJNA675638_P_NODE_5948_length_280_cov_0.995671_g5751_i0	PRJNA675638	5948	280	0.995671	2.7878788	Saccopteryx leptura	249018	Chordata	Chordata	54.7	0.007	NTclustered	gi\|2756211817\|ref\|XM_066357328.1\|	249018	g5751	i0	100	0.103571428571429	29	0	10	0	2	30	1200	1228	PREDICTED: Saccopteryx leptura uncharacterized protein (LOC136386014), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Emballonuridae	Saccopteryx	Saccopteryx leptura
11372507	11372507	PRJNA675638_P_NODE_13609_length_194_cov_1.055172_g13412_i0	PRJNA675638	13609	194	1.055172	2.04703368	Chordata	7711	Chordata	Chordata	54.7	0.005	NTclustered	gi\|56608624\|gb\|AY840232.1\|	8384	g13412	i0	100	14.9484536082474	29	0	15	0	1	29	831	859	Bufo bufo isolate Sumela2 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	2900	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufo	Bufo bufo
13402615	13402615	PRJNA675638_P_NODE_5111_length_299_cov_2.864000_g4914_i0	PRJNA675638	5111	299	2.864	8.56336	Polypterus senegalus	55291	Chordata	Chordata	335	2.47e-87	NTclustered	gi\|1993937637\|ref\|XM_039741126.1\|	55291	g4914	i0	90.038	15.3110367892977	261	23	87	3	40	298	1173	1432	PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA	blastn	4578	335	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
14677642	14677642	PRJNA675638_S_NODE_5292_length_196_cov_1.149660_g5230_i0	PRJNA675638	5292	196	1.14966	2.2533336	Apteryx mantelli	2696672	Chordata	Chordata	54.7	0.005	NTclustered	gi\|840038716\|emb\|LK085257.1\|	202946	g5230	i0	100	0.147959183673469	29	0	15	0	84	112	228	256	Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold20688	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apterygiformes	Apterygidae	Apteryx	Apteryx mantelli
15951238	15951238	PRJNA675638_P_NODE_17133_length_173_cov_0.790323_g16936_i0	PRJNA675638	17133	173	0.790323	1.36725879	Fringilla coelebs	37598	Chordata	Chordata	52.8	0.015	NTclustered	gi\|2917623610\|emb\|OZ228715.1\|	37598	g16936	i0	100	0.161849710982659	28	0	16	0	77	104	4379107	4379134	Fringilla coelebs genome assembly, chromosome: 28	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Fringilla	Fringilla coelebs
17226567	17226567	PRJNA675638_P_NODE_14714_length_187_cov_1.456522_g14517_i0	PRJNA675638	14714	187	1.456522	2.72369614	Spinus spinus	160760	Chordata	Chordata	97.1	7.29e-16	NTclustered	gi\|2917656247\|emb\|OZ228746.1\|	160760	g14517	i0	85.567	2.20855614973262	97	9	49	5	41	132	2660462	2660558	Spinus spinus genome assembly, chromosome: 29	blastn	413	97.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Spinus	Spinus spinus
22325845	22325845	PRJNA675638_P_NODE_10878_length_214_cov_0.933333_g10681_i0	PRJNA675638	10878	214	0.933333	1.99733262	Spinus spinus	160760	Chordata	Chordata	58.4	4.05e-4	NTclustered	gi\|2917633021\|emb\|OZ228725.1\|	160760	g10681	i0	100	1.53738317757009	31	0	16	0	14	44	381663	381633	Spinus spinus genome assembly, chromosome: 8	blastn	329	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Spinus	Spinus spinus
23601349	23601349	PRJNA675638_P_NODE_15599_length_182_cov_1.233083_g15402_i0	PRJNA675638	15599	182	1.233083	2.24421106	Cairina moschata	8855	Chordata	Chordata	52.8	0.015	NTclustered	gi\|2921976028\|gb\|CP130398.1\|	8855	g15402	i0	100	0.153846153846154	28	0	15	0	152	179	9382051	9382078	Cairina moschata breed yongchun chromosome 20	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Anseriformes	Anatidae	Cairina	Cairina moschata
23601385	23601385	PRJNA675638_P_NODE_4579_length_315_cov_1.078947_g4382_i0	PRJNA675638	4579	315	1.078947	3.39868305	Hyaena hyaena	95912	Chordata	Chordata	52.8	0.029	NTclustered	gi\|1965455095\|ref\|XM_039231209.1\|	95912	g4382	i0	100	0.0888888888888889	28	0	9	0	152	179	42	69	PREDICTED: Hyaena hyaena cullin 7 (CUL7), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Hyaenidae	Hyaena	Hyaena hyaena
23601443	23601443	PRJNA675638_S_NODE_9359_length_161_cov_0.875000_g9297_i0	PRJNA675638	9359	161	0.875	1.40875	Sus scrofa	9823	Chordata	Chordata	137	3.59e-28	NTclustered	gi\|224419421\|emb\|CU468098.7\|	9823	g9297	i0	83.007	2.82608695652174	153	24	94	2	6	157	142851	142700	Pig DNA sequence from clone CH242-187J16 on chromosome X, complete sequence	blastn	455	137	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
27808692	27808692	PRJNA675638_P_NODE_15944_length_180_cov_1.129771_g15747_i0	PRJNA675638	15944	180	1.129771	2.0335878	Engystomops pustulosus	76066	Chordata	Chordata	55.8	3.77e-7	NR	KAG8571490.1	76066	g15747	i0	63.9	33.5666666666667	36	13	60	0	178	71	1127	1162	KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus]	diamond	6042	55.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
27966275	27966275	PRJNA675638_P_NODE_21425_length_162_cov_0.902655_g21228_i0	PRJNA675638	21425	162	0.902655	1.4623011	Tupaia chinensis	246437	Chordata	Chordata	41.2	0.0215	NR	ELW72024.1	246437	g21228	i0	72.4	0.537037037037037	29	8	53.7	0	157	71	13	41	ELW72024.1 60S ribosomal protein L7a [Tupaia chinensis]	diamond	87	41.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Scandentia	Tupaiidae	Tupaia	Tupaia chinensis
28345200	28345200	PRJNA675638_P_NODE_11286_length_210_cov_2.534161_g11089_i0	PRJNA675638	11286	210	2.534161	5.3217381	Staurois parvus	386267	Chordata	Chordata	49.3	4.78e-6	NR	CAI9622433.1	386267	g11089	i0	84.6	0.371428571428571	26	4	37.1	0	2	79	7	32	CAI9622433.1 unnamed protein product, partial [Staurois parvus]	diamond	78	49.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
28534875	28534875	PRJNA675638_P_NODE_21067_length_163_cov_0.894737_g20870_i0	PRJNA675638	21067	163	0.894737	1.45842131	Balaenoptera physalus	9770	Chordata	Chordata	48.1	1.61e-4	NR	KAB0394805.1	9770	g20870	i0	62.9	0.644171779141104	35	13	64.4	0	32	136	411	445	KAB0394805.1 hypothetical protein E2I00_000632, partial [Balaenoptera physalus]	diamond	105	48.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Balaenopteridae	Balaenoptera	Balaenoptera physalus
29493691	29493691	PRJNA675638_S_NODE_6110_length_183_cov_1.873134_g6048_i0	PRJNA675638	6110	183	1.873134	3.42783522	Polypteridae	8289	Chordata	Chordata	43.5	0.00921	NR	XP_051788734.1	27687	g6048	i0	80	4.9344262295082	25	5	41	0	109	183	371	395	XP_051788734.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	903	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
29797500	29797500	PRJNA675638_S_NODE_7031_length_172_cov_1.658537_g6969_i0	PRJNA675638	7031	172	1.658537	2.85268364	Erpetoichthys calabaricus	27687	Chordata	Chordata	58.2	4.89e-8	NR	XP_051791274.1	27687	g6969	i0	73.2	3.57558139534884	41	10	69.8	1	53	172	156	196	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	615	58.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
29987178	29987178	PRJNA675638_P_NODE_17571_length_170_cov_1.619835_g17374_i0	PRJNA675638	17571	170	1.619835	2.7537195	Pleurodeles waltl	8319	Chordata	Chordata	52	1.13e-6	NR	KAJ1142759.1	8319	g17374	i0	46.9	9.68823529411765	49	26	86.5	0	148	2	45	93	KAJ1142759.1 hypothetical protein NDU88_009072, partial [Pleurodeles waltl]	diamond	1647	52.4	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
30271795	30271795	PRJNA675638_P_NODE_10172_length_220_cov_1.070175_g9975_i0	PRJNA675638	10172	220	1.070175	2.354385	Polypterus senegalus	55291	Chordata	Chordata	72	9.87e-13	NR	KAG2457453.1	55291	g9975	i0	48.7	1.06363636363636	78	31	96.8	2	5	217	123	198	KAG2457453.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	234	72	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
30650418	30650418	PRJNA675638_P_NODE_16293_length_178_cov_0.868217_g16096_i0	PRJNA675638	16293	178	0.868217	1.54542626	Camelus dromedarius	9838	Chordata	Chordata	53.1	3.12e-6	NR	KAB1282342.1	9838	g16096	i0	48.1	0.910112359550562	54	28	91	0	168	7	15	68	KAB1282342.1 Histone-lysine N-methyltransferase SETD7, partial [Camelus dromedarius]	diamond	162	53.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Camelidae	Camelus	Camelus dromedarius
30757270	30757270	PRJNA675638_P_NODE_8414_length_239_cov_0.989474_g8217_i0	PRJNA675638	8414	239	0.989474	2.36484286	Passeriformes	9126	Chordata	Chordata	40.4	0.0495	NR	NXF24574.1	58203	g8217	i0	64.3	0.677824267782427	28	10	35.1	0	228	145	26	53	NXF24574.1 ZFP2 protein [Rhodinocichla rosea]	diamond	162	40.8	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Thraupidae	Rhodinocichla	Rhodinocichla rosea
30840240	30840240	PRJNA675638_S_NODE_6554_length_178_cov_0.930233_g6492_i0	PRJNA675638	6554	178	0.930233	1.65581474	Engystomops pustulosus	76066	Chordata	Chordata	56.6	2.01e-7	NR	KAG8571490.1	76066	g6492	i0	65.4	11.5112359550562	52	17	87.6	1	165	10	1044	1094	KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus]	diamond	2049	56.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
31009971	31009971	PRJNA675638_P_NODE_14174_length_190_cov_1.446809_g13977_i0	PRJNA675638	14174	190	1.446809	2.7489371	Metazoa	33208	Chordata	Chordata	53.9	1.87e-6	NR	CAK8641272.1	30338	g13977	i0	56.1	2.06842105263158	41	18	64.7	0	190	68	233	273	CAK8641272.1 Retrovirus-related Pol polyprotein from transposon RE1 [Bufotes viridis]	diamond	393	54.3	0.992633517495396	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
31314267	31314267	PRJNA675638_P_NODE_7215_length_256_cov_0.888889_g7018_i0	PRJNA675638	7215	256	0.888889	2.27555584	Neogale vison	452646	Chordata	Chordata	45.1	0.00648	NR	XP_044116080.1	452646	g7018	i0	47.1	0.8671875	34	18	39.8	0	28	129	337	370	XP_044116080.1 zinc finger protein 3-like [Neogale vison]	diamond	222	45.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Neogale	Neogale vison
31599118	31599118	PRJNA675638_P_NODE_20056_length_164_cov_0.886957_g19859_i0	PRJNA675638	20056	164	0.886957	1.45460948	Engystomops pustulosus	76066	Chordata	Chordata	40.8	0.00973	NR	KAG8584541.1	76066	g19859	i0	80	0.365853658536585	20	4	36.6	0	119	60	15	34	KAG8584541.1 hypothetical protein GDO81_004655 [Engystomops pustulosus]	diamond	60	40.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
31820215	31820215	PRJNA675638_P_NODE_20477_length_164_cov_0.860870_g20280_i0	PRJNA675638	20477	164	0.86087	1.4118268	Polypterus senegalus	55291	Chordata	Chordata	51.6	9.24e-6	NR	KAG2460242.1	55291	g20280	i0	53.7	33.5853658536585	54	25	98.8	0	162	1	235	288	KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	5508	51.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
31895414	31895414	PRJNA675638_S_NODE_7637_length_167_cov_0.864407_g7575_i0	PRJNA675638	7637	167	0.864407	1.44355969	Metazoa	33208	Chordata	Chordata	48.1	1.65e-4	NR	XP_066845326.1	8845	g7575	i0	57.6	15.1077844311377	33	14	59.3	0	8	106	338	370	XP_066845326.1 LOW QUALITY PROTEIN: zinc finger and BTB domain-containing protein 3-like [Anser cygnoides]	diamond	2523	48.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Anseriformes	Anatidae	Anser	Anser cygnoides
32073502	32073502	PRJNA675638_P_NODE_14898_length_186_cov_0.956204_g14701_i0	PRJNA675638	14898	186	0.956204	1.77853944	Staurois parvus	386267	Chordata	Chordata	57.8	6.18e-9	NR	CAI9547784.1	386267	g14701	i0	43.9	0.919354838709677	57	32	91.9	0	3	173	31	87	CAI9547784.1 unnamed protein product, partial [Staurois parvus]	diamond	171	57.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
32200083	32200083	PRJNA675638_P_NODE_20118_length_164_cov_0.886957_g19921_i0	PRJNA675638	20118	164	0.886957	1.45460948	Bufotes viridis	30338	Chordata	Chordata	42	0.0239	NR	CAK8629749.1	30338	g19921	i0	50	1.44512195121951	42	21	76.8	0	144	19	323	364	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	237	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
32705460	32705460	PRJNA675638_P_NODE_20560_length_163_cov_1.789474_g20363_i0	PRJNA675638	20560	163	1.789474	2.91684262	Staurois parvus	386267	Chordata	Chordata	53.1	4.07e-7	NR	CAI9557087.1	386267	g20363	i0	63.9	1.32515337423313	36	11	62.6	1	117	16	24	59	CAI9557087.1 unnamed protein product, partial [Staurois parvus]	diamond	216	53.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus

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