metadata: contig_metadata: 31 rows where bioproject = "PRJNA1066877" and tax

31 rows where bioproject = "PRJNA1066877" 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
1455116	1455116	PRJNA1066877_S_NODE_7302_length_199_cov_0.886667_g7267_i0	PRJNA1066877	7302	199	0.886667	1.76446733	Panthera onca	9690	Chordata	Chordata	270	4.38e-68	NTclustered	gi\|2614040919\|ref\|XR_009607094.1\|	9690	g7267	i0	95.294	104.21608040201	170	8	85	0	16	185	1275	1444	PREDICTED: Panthera onca uncharacterized LOC132671422 (LOC132671422), ncRNA	blastn	20739	270	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Panthera	Panthera onca
3563600	3563600	PRJNA1066877_S_NODE_3643_length_257_cov_1.375000_g3608_i0	PRJNA1066877	3643	257	1.375	3.53375	Felidae	9681	Chordata	Chordata	436	5.52e-118	NTclustered	gi\|223634045\|gb\|AC234647.1\|	9685	g3608	i0	97.276	140.669260700389	257	7	100	0	1	257	155925	156181	Felis catus BAC clone FCAB-10H12 from chromosome unknown, complete sequence	blastn	36152	436	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
3563665	3563665	PRJNA1066877_S_NODE_6523_length_207_cov_0.955696_g6488_i0	PRJNA1066877	6523	207	0.955696	1.97829072	Canis	9611	Chordata	Chordata	383	5.65e-102	NTclustered	gi\|1239888293\|ref\|XM_848255.5\|	9615	g6488	i0	100	99.7101449275362	207	0	100	0	1	207	622	416	PREDICTED: Canis lupus familiaris glia maturation factor gamma (GMFG), transcript variant X5, mRNA	blastn	20640	383	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
4006855	4006855	PRJNA1066877_S_NODE_5964_length_214_cov_0.927273_g5929_i0	PRJNA1066877	5964	214	0.927273	1.98436422	Malaclemys terrapin	8485	Chordata	Chordata	396	7.559999999999996e-106	NTclustered	gi\|2451710313\|ref\|XM_054041543.1\|	2991368	g5929	i0	100	93.1542056074766	214	0	100	0	1	214	2039	2252	PREDICTED: Malaclemys terrapin pileata Rac family small GTPase 1 (RAC1), mRNA	blastn	19935	396	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Emydidae	Malaclemys	Malaclemys terrapin
5283238	5283238	PRJNA1066877_S_NODE_5885_length_215_cov_0.765060_g5850_i0	PRJNA1066877	5885	215	0.76506	1.644879	Felis catus	9685	Chordata	Chordata	259	1.04e-64	NTclustered	gi\|2131013965\|ref\|XR_002160862.2\|	9685	g5850	i0	88.94	177.125581395349	217	15	100	5	1	215	1307	1516	PREDICTED: Felis catus uncharacterized LOC109502313 (LOC109502313), ncRNA	blastn	38082	259	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
5283260	5283260	PRJNA1066877_S_NODE_6965_length_202_cov_1.000000_g6930_i0	PRJNA1066877	6965	202	1	2.02	Bos taurus	9913	Chordata	Chordata	337	4.34e-88	NTclustered	gi\|1068294018\|gb\|KX592814.1\|	9913	g6930	i0	98.942	904.217821782178	189	1	97	1	15	202	2764971	2765159	Bos taurus isolate Dominette_000065F genomic sequence	blastn	182652	337	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
6558214	6558214	PRJNA1066877_S_NODE_10366_length_174_cov_0.792000_g10331_i0	PRJNA1066877	10366	174	0.792	1.37808	Panthera uncia	29064	Chordata	Chordata	196	6.39e-46	NTclustered	gi\|2277552762\|ref\|XM_049617277.1\|	29064	g10331	i0	95.161	97.4770114942529	124	6	71	0	1	124	4493	4370	PREDICTED: Panthera uncia leucine rich adaptor protein 1 (LURAP1), mRNA	blastn	16961	196	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Panthera	Panthera uncia
6558350	6558350	PRJNA1066877_S_NODE_5846_length_215_cov_1.313253_g5811_i0	PRJNA1066877	5846	215	1.313253	2.82349395	Felis catus	9685	Chordata	Chordata	381	2.1299999999999996e-101	NTclustered	gi\|238814447\|gb\|AC236716.1\|	9685	g5811	i0	98.605	91.0976744186047	215	3	100	0	1	215	45448	45662	Felis catus BAC clone FCAB-34H12 from chromosome unknown, complete sequence	blastn	19586	381	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
9107909	9107909	PRJNA1066877_S_NODE_12048_length_164_cov_1.330435_g12013_i0	PRJNA1066877	12048	164	1.330435	2.1819134	Felis catus	9685	Chordata	Chordata	303	3.42e-78	NTclustered	gi\|823758741\|gb\|KP081775.1\|	9685	g12013	i0	100	65.7987804878049	164	0	100	0	1	164	1243902	1244065	Felis catus chromosome Y genomic sequence	blastn	10791	303	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
9108096	9108096	PRJNA1066877_S_NODE_9568_length_180_cov_0.755725_g9533_i0	PRJNA1066877	9568	180	0.755725	1.360305	Neofelis nebulosa	61452	Chordata	Chordata	174	3.12e-39	NTclustered	gi\|2558881960\|ref\|XR_009262994.1\|	61452	g9533	i0	86.875	78.6166666666667	160	16	86	3	5	159	2417	2576	PREDICTED: Neofelis nebulosa uncharacterized LOC131514236 (LOC131514236), ncRNA	blastn	14151	174	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Neofelis	Neofelis nebulosa
10383589	10383589	PRJNA1066877_S_NODE_12509_length_163_cov_0.859649_g12474_i0	PRJNA1066877	12509	163	0.859649	1.40122787	Acinonyx jubatus	32536	Chordata	Chordata	243	7.51e-60	NTclustered	gi\|2437655263\|ref\|XM_053211125.1\|	32536	g12474	i0	94.872	98.1042944785276	156	6	96	1	2	157	11649	11496	PREDICTED: Acinonyx jubatus cyclic nucleotide gated channel subunit beta 1 (CNGB1), mRNA	blastn	15991	243	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Acinonyx	Acinonyx jubatus
11658892	11658892	PRJNA1066877_S_NODE_12390_length_163_cov_0.912281_g12355_i0	PRJNA1066877	12390	163	0.912281	1.48701803	Prionailurus bengalensis	37029	Chordata	Chordata	279	5.73e-71	NTclustered	gi\|2092084960\|ref\|XM_043585510.1\|	37029	g12355	i0	97.561	12.5521472392638	164	2	100	2	1	163	612	774	PREDICTED: Prionailurus bengalensis translation initiation factor IF-2-like (LOC122486039), mRNA	blastn	2046	279	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Prionailurus	Prionailurus bengalensis
12491991	12491991	PRJNA1066877_S_NODE_8330_length_190_cov_0.787234_g8295_i0	PRJNA1066877	8330	190	0.787234	1.4957446	Felidae	9681	Chordata	Chordata	285	1.4799999999999998e-72	NTclustered	gi\|16356884\|gb\|AC093141.2\|	9685	g8295	i0	94.149	83.9842105263158	188	9	99	2	1	188	118781	118596	Felis catus clone RP86-512F4, complete sequence	blastn	15957	285	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
14208951	14208951	PRJNA1066877_S_NODE_10072_length_176_cov_1.094488_g10037_i0	PRJNA1066877	10072	176	1.094488	1.92629888	Felis catus	9685	Chordata	Chordata	270	3.77e-68	NTclustered	gi\|193506888\|gb\|EU153401.1\|	9685	g10037	i0	94.318	144.136363636364	176	10	100	0	1	176	2274603	2274778	Felis catus FLA extended class II, class II, class III, proximal and central class I region genomic sequence	blastn	25368	270	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
14209002	14209002	PRJNA1066877_S_NODE_12412_length_163_cov_0.894737_g12377_i0	PRJNA1066877	12412	163	0.894737	1.45842131	Bos taurus	9913	Chordata	Chordata	302	1.22e-77	NTclustered	gi\|2587618203\|ref\|XR_009493738.1\|	9913	g12377	i0	100	22.1288343558282	163	0	100	0	1	163	2956	2794	PREDICTED: Bos taurus uncharacterized lncRNA (LOC132344779), transcript variant X2, ncRNA	blastn	3607	302	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
14209120	14209120	PRJNA1066877_S_NODE_5972_length_213_cov_45.682927_g5937_i0	PRJNA1066877	5972	213	45.682927	97.30463451	Meles meles	9662	Chordata	Chordata	54.7	0.005	NTclustered	gi\|1190059416\|emb\|LT800002.1\|	9662	g5937	i0	100	0.530516431924883	29	0	14	0	185	213	58	30	Meles meles mRNA for Enzyme (Glyceraldehyde 3-phosphate dehydrogenase gene)	blastn	113	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Mustelidae	Meles	Meles meles
15483253	15483253	PRJNA1066877_S_NODE_9813_length_178_cov_1.000000_g9778_i0	PRJNA1066877	9813	178	1	1.78	Sus scrofa	9823	Chordata	Chordata	274	2.95e-69	NTclustered	gi\|2103\|emb\|X16513.1\|	9823	g9778	i0	94.886	23.4775280898876	176	7	99	2	3	178	902	729	Pig gender-neutral repetitive DNA	blastn	4179	274	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
16315563	16315563	PRJNA1066877_S_NODE_9753_length_178_cov_1.403101_g9718_i0	PRJNA1066877	9753	178	1.403101	2.49751978	Felidae	9681	Chordata	Chordata	279	6.35e-71	NTclustered	gi\|34304133\|gb\|AC144403.2\|	9685	g9718	i0	94.972	148.196629213483	179	8	100	1	1	178	37910	38088	Felis catus clone RP86-60G24, complete sequence	blastn	26379	279	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
16757183	16757183	PRJNA1066877_S_NODE_10154_length_175_cov_1.444444_g10119_i0	PRJNA1066877	10154	175	1.444444	2.527777	Sus scrofa	9823	Chordata	Chordata	209	8.27e-50	NTclustered	gi\|1228416823\|gb\|KY514491.1\|	9823	g10119	i0	88.136	6.98285714285714	177	19	100	2	1	175	170	346	Sus scrofa clone SSC_CL_D satellite FA-SAT related sequence sequence	blastn	1222	209	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
17590700	17590700	PRJNA1066877_S_NODE_11914_length_165_cov_0.879310_g11879_i0	PRJNA1066877	11914	165	0.87931	1.4508615	Panthera	9688	Chordata	Chordata	261	2.11e-65	NTclustered	gi\|2613977894\|ref\|XR_009617009.1\|	9690	g11879	i0	95.152	28.230303030303	165	8	100	0	1	165	3916	3752	PREDICTED: Panthera onca uncharacterized LOC132693856 (LOC132693856), ncRNA	blastn	4658	261	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Panthera	Panthera onca
18032130	18032130	PRJNA1066877_S_NODE_6115_length_212_cov_0.981595_g6080_i0	PRJNA1066877	6115	212	0.981595	2.0809814	Acinonyx jubatus	32536	Chordata	Chordata	333	5.939999999999998e-87	NTclustered	gi\|2437616651\|ref\|XR_003425039.2\|	32536	g6080	i0	95.673	119.533018867925	208	8	98	1	2	209	5723	5517	PREDICTED: Acinonyx jubatus uncharacterized LOC113603446 (LOC113603446), transcript variant X4, ncRNA	blastn	25341	333	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Acinonyx	Acinonyx jubatus
18032157	18032157	PRJNA1066877_S_NODE_755_length_477_cov_1.044393_g721_i0	PRJNA1066877	755	477	1.044393	4.98175461	Felis catus	9685	Chordata	Chordata	736	0	NTclustered	gi\|193506888\|gb\|EU153401.1\|	9685	g721	i0	97.887	149.832285115304	426	7	100	1	1	426	2141858	2142281	Felis catus FLA extended class II, class II, class III, proximal and central class I region genomic sequence	blastn	71470	736	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
20581464	20581464	PRJNA1066877_S_NODE_4077_length_247_cov_1.015152_g4042_i0	PRJNA1066877	4077	247	1.015152	2.50742544	Panthera tigris	9694	Chordata	Chordata	305	1.55e-78	NTclustered	gi\|2080433455\|ref\|XR_006210749.1\|	9694	g4042	i0	89.958	0.967611336032389	239	20	97	2	1	239	2743	2977	PREDICTED: Panthera tigris uncharacterized LOC122233230 (LOC122233230), ncRNA	blastn	239	305	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Panthera	Panthera tigris
21857165	21857165	PRJNA1066877_S_NODE_1758_length_339_cov_1.096552_g1723_i0	PRJNA1066877	1758	339	1.096552	3.71731128	Felis catus	9685	Chordata	Chordata	599	9.119999999999999e-167	NTclustered	gi\|108792681\|gb\|AC174433.3\|	9685	g1723	i0	98.525	129.283185840708	339	5	100	0	1	339	103167	103505	Felis catus clone RP86-496K24, complete sequence	blastn	43827	599	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
21857231	21857231	PRJNA1066877_S_NODE_5378_length_222_cov_0.803468_g5343_i0	PRJNA1066877	5378	222	0.803468	1.78369896	Acinonyx jubatus	32536	Chordata	Chordata	372	1.33e-98	NTclustered	gi\|2437630465\|ref\|XM_053204342.1\|	32536	g5343	i0	96.847	44.3288288288288	222	7	100	0	1	222	877	656	PREDICTED: Acinonyx jubatus skin secretory protein xP2-like (LOC128312037), transcript variant X1, mRNA	blastn	9841	372	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Acinonyx	Acinonyx jubatus
21857258	21857258	PRJNA1066877_S_NODE_6698_length_205_cov_0.980769_g6663_i0	PRJNA1066877	6698	205	0.980769	2.01057645	Ursus maritimus	29073	Chordata	Chordata	102	1.75e-17	NTclustered	gi\|2023589691\|ref\|XR_568129.2\|	29073	g6663	i0	85.149	36.6634146341463	101	13	48	2	4	102	2394	2294	PREDICTED: Ursus maritimus 60S ribosomal protein L18a-like (LOC103661504), transcript variant X14, misc_RNA	blastn	7516	102	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Ursidae	Ursus	Ursus maritimus
23965517	23965517	PRJNA1066877_S_NODE_8539_length_188_cov_1.100719_g8504_i0	PRJNA1066877	8539	188	1.100719	2.06935172	Canis	9611	Chordata	Chordata	348	1.84e-91	NTclustered	gi\|1953301484\|ref\|XM_038690009.1\|	9615	g8504	i0	100	21.4042553191489	188	0	100	0	1	188	1485	1672	PREDICTED: Canis lupus familiaris store-operated calcium entry associated regulatory factor (SARAF), transcript variant X3, mRNA	blastn	4024	348	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
24406263	24406263	PRJNA1066877_S_NODE_1560_length_356_cov_1.364821_g1525_i0	PRJNA1066877	1560	356	1.364821	4.85876276	Felis catus	9685	Chordata	Chordata	641	1.5699999999999994e-179	NTclustered	gi\|1524311835\|gb\|MH270418.1\|	9685	g1525	i0	99.157	110.51404494382	356	3	100	0	1	356	83575	83930	Felis catus clone RPCI-86:531C17-Y2 CCDC71LY (CCDC71LY) gene, partial cds; and TSPY (TSPY) gene, complete cds	blastn	39343	641	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Felis	Felis catus
27730828	27730828	PRJNA1066877_S_NODE_12144_length_164_cov_0.886957_g12109_i0	PRJNA1066877	12144	164	0.886957	1.45460948	Rangifer tarandus platyrhynchus	3082113	Chordata	Chordata	42	0.00688	NR	CAI9176387.1	3082113	g12109	i0	66.7	0.439024390243902	24	8	43.9	0	55	126	75	98	CAI9176387.1 unnamed protein product [Rangifer tarandus platyrhynchus]	diamond	72	42	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Rangifer	Rangifer tarandus
31331017	31331017	PRJNA1066877_S_NODE_1416_length_370_cov_1.906542_g1381_i0	PRJNA1066877	1416	370	1.906542	7.0542054	Lynx pardinus	191816	Chordata	Chordata	47.4	0.00323	NR	VFV37723.1	191816	g1381	i0	58	0.405405405405405	50	21	40.5	0	38	187	4	53	VFV37723.1 Hypothetical predicted protein [Lynx pardinus]	diamond	150	47.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Lynx	Lynx pardinus
32871522	32871522	PRJNA1066877_S_NODE_12740_length_162_cov_0.858407_g12705_i0	PRJNA1066877	12740	162	0.858407	1.39061934	Delphinidae	9726	Chordata	Chordata	46.2	7.57e-4	NR	XP_049562359.1	9733	g12705	i0	52.7	3.05555555555556	55	20	90.7	1	162	16	80	134	XP_049562359.1 protein farnesyltransferase subunit beta isoform X3 [Orcinus orca]	diamond	495	46.6	0.991416309012876	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Delphinidae	Orcinus	Orcinus orca

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